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?