Formula question

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

How do I write this formula?

In a cell I want to put what what the answer is of another
except if that answer is zero then I want nothing in the
other cell.
 
One way:

B1: =IF(A1=0,"",A1)


Note that "" isn't really "nothing" - any cell with a formula has
*something* returned as a value.
 
Back
Top