Excel Tip #5: _Not Equal To_

Actuary Forums › Forums › Learnings › Softwares › Excel › Excel Tip #5: _Not Equal To_

  • This topic is empty.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • July 31, 2019 at 2:05 pm #23528
    Rishabh Surana
    Moderator

      “Not equal to” in excel is represented by symbol “<>“

      <> is a logical operator & can be used in any formula to give criteria/conditions.

      Example:

      1. =if(A2<>B2,C2,D2) i.e. If A2 not equals B2, it will return C2 else D2.

      2. =if(A2<>“”,”Rishabh”,””) i.e. If A2 is not blank, it will return Rishabh otherwise blank.

    • Author
      Posts
    Viewing 1 post (of 1 total)
    • You must be logged in to reply to this topic.

    Actuary Forums › Forums › Learnings › Softwares › Excel › Excel Tip #5: _Not Equal To_