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
