how to create a formula
=IF(C3=0,"",IF(AND(C3=C4,C5<C2),1,""))
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.
"Fred Golfer" wrote:
I want to create a formula as follows:-
if(c3=c4) and(c5<2) I want a "1" displayed or else a blank. Also if(c3=0) I
want a blank. I have tried to create a formula and it works but it displays
either "TRUE" or "FALSE" which I do not want to display.
Any help will be appreciated.
|