CODEWITHSUNDEEP
excel
mono92
mono92

Reputation: 17

Incorrect If formula

As I'm still getting the hang of excel I'm not 100% sure why this formula isn't working! 

=IF(OR(ISBLANK(L6),ISBLANK(M6)),"";IF( L6 >= M2,"True","False")

I'm trying to do a true, false check for cols L and M but as there are blanks in there I need to check for them as well. For the blanks, I just want to make them "".

Upvotes: 0

Views: 37

Answers (1)

G42
G42

Reputation: 10019

  • As per Gowtham's comment, you are missing some brackets.
  • Use , or ; to delimit parts of the IF statement. Not both.
  • true and false are special words in Excel. They do not need to have quotes " around them like regular strings.
=IF(OR(ISBLANK(L6),ISBLANK(M6)),"",IF(A1>B1,TRUE,FALSE))

Edit
As per jsheeran's comment this can be simplified further as Excel will automatically evaluate A1>B1 to true or false.

=IF(OR(ISBLANK(L6),ISBLANK(M6)),"",A1>B1)

Upvotes: 1

Related Questions