Forum Discussion
IF Formula
I am trying to do an IF formula for if something is greater than or equal to and it will pass/fail. Pretty simple. However in my IF formula, I am selecting a cell that has another IF formula ...
My guess is that IF() in another cell for some conditions returns empty string =IF(condition, result, "").
In current cell IF() takes this result, compare with something and returns Pass or Fail.
If first IF returns empty string, that's not null and not zero, that's text. And in Excel any text is more than any number in comparing, i.e. ="">60 returns TRUE