Ignoring blank cells

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

Guest

Hi

I am using this formula in cell B1 =Sign(A1)

It works but if A1 is blank it shows #VALUE! I would like the formula to
ignore blank cells and appear blank.

Thanks
 
This should suffice:
=IF(A1="","",SIGN(A1))

Think you were hitting the text zero length null strings: "" (return by
formulas) rather than real blanks in the VALUE error. Real blanks would be
evaluated by SIGN to return zero.
 
Thanks Max

That is a great help

Max said:
This should suffice:
=IF(A1="","",SIGN(A1))

Think you were hitting the text zero length null strings: "" (return by
formulas) rather than real blanks in the VALUE error. Real blanks would be
evaluated by SIGN to return zero.
Click to expand...
 
Back
Top