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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Neil" wrote:
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