how to create a formula
 

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.

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.

how to create a formula
 

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

how to create a formula
 

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

"Max" wrote:

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

how to create a formula
 

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
---