Sum Function

[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

 

[Leo Heuser]

Kacy

One way:

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


--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

 

[Harlan Grove]

...
...

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

Eliminate the SUM - it's unnecessary.

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

is sufficient.

 

[Kacy]

-----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

still doing wrong.

Thanks,
Kacy

 

[Leo Heuser]

You're welcome, Kacy.

LeoH

Thanks,
Kacy

 

[Adrian Key]

You might try: =IF(ISBLANK(D11),"N/A",F10+D11-E11)