Sorry - i am not great with formula and I am using a sheet already set up by someone who has left and i need this formula to look at two cells and add them together but return nothing if it is blank - but i have a #VALUE! returned - the cells contain minus numbers - i can;t figure out what is wrong - can someone assist me please? It does the sum ok when i put the info in but has the VALUE while it is blank......
=IF(OR(ISBLANK(K19),ISBLANK(M17)),"",SUM(K19+M17))
Do the 2 cells contain formulas, and the 'blank' is actually a "" result from that formula?
"" is NOT blank, it's a zero length text string. So ISBLANK will return FALSE.
Text+Number = #VALUE! error.
Try
=IF(COUNT(K19,M17)=2,SUM(K19,M17),"")
Last edited by Jonmo1; 07-05-2016 at 08:58 AM.
Try this:
=IF(AND(ISBLANK(K19),ISBLANK(M17)),"",SUM(K19+M17))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe this...
=IF(COUNT(K19,M17)<2,"",K19+M17)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try this
Please Login or Register to view this content.
Kamboj
_________________________________________________________________________________
Mark the thread as SOLVED if my answer satisfy you.
This worked perfectly - thank you so much
all working perfectly now - thank you all for your help
You're welcome!
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks