Hello,
I'm trying to add to column B & Column C, column C has value n/a, when adding two columns I get #value! error
if error is n/a it should add the value.
I tried, if iserror, if isna, but no luck.
please see attached spreadsheet, column E is desired result.
Thanks
Try this
=IF(ISNA(C5),B5,SUM(B5:C5))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
In your example N/A is just a text. Not error from a formula.
In your example, this will work. In E2 and copy down.
=IF(C2="n/a",B2,SUM(B2:C2))
Or else
=IF(ISNA(C2),B2,SUM(B2:C2))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks Foris1991. Appreciate your help. It worked.
How can you tell this is a text field and not the standard N/A error?
Sorry for later reply back..overlooked it..
If it was just a text string "N/A", then a basic SUM(B5:C5) will work (it ignores text)
If it was an actual formula error, then the basic sum formula will error as well.
If in C5 exist a n/a, then in an empty cell, try this.
=ISTEXT(C5)
Will gives you TRUE as result if it is a text and formula error.
Thanks Jonmo1 - I always wondered about that. You're explanation really cleared it up. Thanks Fotis1991, good way to test it there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks