how to create a formula

[Fred Golfer]

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.

 

[John C]

=IF(C3=0,"",IF(AND(C3=C4,C5<C2),1,""))

 

[Max]

Try: =IF(AND(C3=C4,C5<2),1,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik

 

[John C]

And if C3 =0 and C4=0?
--
** John C **

Try: =IF(AND(C3=C4,C5<2),1,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik

 

[Max]

Agreed. I missed that bit in the OP after the "also".
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---