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