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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average formula where blank cells are counted as zeros 4
COUNTIFS ? 1
conditional formula 12
Can multiple criteria be used for IF formulas? 4
formula 6
How to count the maximum number flanked by zeros 9
checking two different cells 1
Adding recognised Zeros 5

Back
Top