ExcelBanter - Ignoring blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Ignoring blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/158285-ignoring-blank-cells.html)

Neil

Ignoring blank cells

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

Max

Ignoring blank cells

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

Neil

Ignoring blank cells

Thanks Max

That is a great help

"Max" wrote:

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

Max

Ignoring blank cells

welcome, Neil.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Neil" wrote in message
...
Thanks Max

That is a great help

All times are GMT +1. The time now is 04:25 PM.