IF function

[akumar61]

Anyone know how to alter math functions so that a blank is returned if the target cell is blank. For example, if a cell is <1, return 0, if >1 return 2, and if blank, then return blank

Thank

anand

 

[Frank Kabel]

Hi Anand
try
=IF(A1="","",IF(A1>1,2,IF(A1<=1,0))
Note: I included the value 1 in the third condition (your description
was ambiguous for the value '1')

HTH
Frank

 

[Eechhutti R.Rajasekaran]

You can try this:
If (A1>=1, 1, If(A1 <1, 0, " ")

Raja

 

[Frank Kabel]

You can try this:
If (A1>=1, 1, If(A1 <1, 0, " ")

Raja

Hi Raja
this will work fine unleass A1 is empty. then this formula will return
'0' as A1<1 is evaluated to TRUE.

Frank

 

[Eechhutti R.Rajasekaran]

I stand corrected. Thank you.

Eechhutti R.Rajasekaran