Sum Function

  • Thread starter Thread starter Kacy
  • Start date Start date
K

Kacy

I'm attempting to write a formuala that if a certain cell
is blank it puts a "N/A" into the formula cell. However I
reference the previous cell to do a sum and if that cell
contains a "N/A" it will not sum it correctly. Here is
the formula that I'm currently using.


This formula is in cell F11....

=IF(D11<>"",SUM(F10+D11-E11),"N/A")

So if F10 contains "N/A" I get a #VALUE! error. Anyway to
ignore the "N/A" and just add numeric values.

Thanks in advance,
Kacy
 
Kacy

One way:

=IF(D11<>"",D11-E11+IF(ISNA(F10),0,F10),NA())


--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
-----Original Message-----
Kacy

One way:

=IF(D11<>"",D11-E11+IF(ISNA(F10),0,F10),NA())


--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.




.
I'm still getting a #Value error....Not for sure what I'm
Click to expand...
still doing wrong.

Thanks,
Kacy
 
Back
Top