Why would this = nothing?

[SandsB]

The value in B15 is 0

The value in C15 is 525

D15 is =IF(B15=0,NA(),B15). I made this spreadsheet so many years ago I forgot why I used that formula, but I think it had something to do with some charts in a file somebody else made to use my data.
D15 is blank

E15 is =IF(C15=0,NA(),C15).
E15 has a value of 525

F15 is =D15+E15 and is blank, not 525. Why is that?

 

[Skyybot]

Have you tried the Open and Repair option?

 

[Fluff]

That formula will return #N/A if B15 is blank or zero. It sounds like you have hidden the errors in some way, possibly by conditional formatting.

 

[SandsB]

B15 has never been 0 before and it's always worked.

 

[SandsB]

Have you tried the Open and Repair option?

Have you tried the Open and Repair option?

Yes - didn't find anything

 

[SandsB]

Conditional formatting is =ISNA(F3).

That formula will return #N/A if B15 is blank or zero. It sounds like you have hidden the errors in some way, possibly by conditional formatting.

That formula will return #N/A if B15 is blank or zero. It sounds like you have hidden the errors in some way, possibly by conditional formatting.

Fluff is right, Conditional formatting with a white font hid the true value of #N/A. Anybody know a better way to get =D15+E15 if the value of one of those 2 cells is #N/A?

 

[Alex Blakenburg]

You could try something like:

=IF(ISNA(D15),0,D15)+E15

 

[SandsB]

You could try something like:

=IF(ISNA(D15),0,D15)+E15

Perfect - thank you

 

[Scott Huish]

If you want 0 if either value is #N/A
=IFNA(D15+E15,0)

 

[Alex Blakenburg]

Perfect - thank you

Thanks for letting us know. Glad we could help. @Fluff did the hard part in identifying that the conditional formatting was hiding the #NA.

If you want 0 if either value is #N/A
=IFNA(D15+E15,0)

In case the OP doesn't comment further, The NA in D15 was used purely to make the chart work but for calculation purposes it needed to be 0.