ExcelBanter - IF formula

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

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

- - IF formula (https://www.excelbanter.com/excel-discussion-misc-queries/132414-if-formula.html)

Sarah

IF formula

If a cell value equals zero I want it to be blank. How would I word the
formula?

T. Valko

IF formula

Try this:

=IF(A1=0,"",do_something_else)

If A1 is either empty or contains the number 0 the formula returns a blank.

Biff

"sarah" wrote in message
...
If a cell value equals zero I want it to be blank. How would I word the
formula?

tim m

IF formula

You can suppress zeros by going 'tools'....'options'...'view' tab and then
uncheck the zero values box. do you just not want to see the zeros or do you
actually want to put a blank into the cell?

"sarah" wrote:

If a cell value equals zero I want it to be blank. How would I word the
formula?

All times are GMT +1. The time now is 02:52 AM.