MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF Formula


Posted by Steve on January 09, 2001 2:06 PM

I'm trying to use an IF Function and I'm doing something wrong because it will return the proper answer - over,under,paid but not open when there is a zero. See formula IF(K3=F3,"paid",IF(K3>F3,"over",IF(K3<G3,"under",IF(K3=0,"open"))))
Any help would be apprecaited.


Posted by dd on January 09, 2001 2:17 PM

Shouldn't the G3 in your formula be F3 ?
With G3 the result will be FALSE if K3 is less than F3 or if K3 is larger than G3.

Anyway, try your formula like this :-
=IF(K3=0,"open",IF(K3=F3,"paid",IF(K3>F3,"over",IF(K3<G3,"under"))))

Posted by Aladin Akyurek on January 09, 2001 2:25 PM

Try:

=IF(K3=0,"Open",IF(K3>F3,"Over",IF(K3 LessThan G3,"Under","NoValue")))

Note. Replace LessThan by the appropriate relational symbol.

Aladin