IF function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
You can try this:
If (A1>=1, 1, If(A1 <1, 0, " ")

Raja
Click to expand...

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

Frank
 
Back
Top