Add two cells but one is zero.

J

JBjarnason

New member
Joined
Apr 23, 2018
Messages
10
Reaction score
0
Points
0
Excel Version(s)
10
I want to add two cells and one cell is a zero. One cell has say 3 in it and the other cell is zero, my answer shows up as "VALUE", how can I get it to show 3?
 
Excel 2007 32 bit
A​
B​
C​
D​
E​
F​
G​
1​
3​
2​
0​
3​
3​
<-- =SUM(D1: D2)
Sheet: Sheet1

The SUM formula works well here. What formula are you using ?
 
=SUM(D21+S21) The cells are in different places.
 
Either one or both of the cells you are trying to sum are not really numbers.
 
You're right. One cell is a formula and there isn't a number there all the time.
 
That won't be it by itself. Attach a sample workbook, otherwise we are just guessing.
 
.
I believe if you change the formula in S5 to : =IF(S3>70, S3-70,"0")
 
Amend the formula in cell S5. from:

Code: 
=IF(S3>70, S3-70,"")

to this:
Code: 
=MAX(S3-70,0)

If you don't want to see a zero in cell S5, then just change the format, but not the value.

Cheers,
 
You must log in or register to reply here.
Back
Top