Hiding the value of a formula if 1 cell has a value of zero.

D

duugg

I have a spreadsheet set up and would like to hide the value of a
formula if one cell has a zero value.

for example...

A1, value is 0
A2, value is 22

A3 (formula) is A1 + A2

But if A1 is zero, I want A3 to show nothing, how do I do this?

thanks in advance
 
G

Guest

You could probably use an if statement :
=if(A1=0,"",A1+A2)

or you could use conditional formatting, depending on what you want to do
exactly.

Neda
 
D

duugg

If I'm using this formula...

=IF(F24="","",F22+F24)

In cell F26


and this formula

=IF(F20="","",F18+F20)

is in cell F22

and

1

is in cell F24

I got a #value! error

Why is this the case when there is indeed a number 1 in cell
F24?
 

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

Excel formula, sum the value cell and if empty cell left blank 0
sum if 3
How do I make this work? 15
matching cell formula 1
Vlookup with If condition 1
Change Color of cell 3
showing formula and its value simultaneously 2
Return latest value from data range 4

Top