Being abit new at this I am wondeing why the formula below works out but returns a #VALUE! message insted of the numeric answer?
What I am trying to do is post a "0" in M15 if there is no value in M11:M13 to subtract from the sum contained in K5.
Function argument shows correct result.
=IF(SUM(M11:M13 <1),0,SUM(K5-M14)), with numbers only in those cells.
Abit of help would be appreciated, Thanks
Hi
This is an Array Formula.
Close it not just with Enter, but using Control+Shifr+Enter, all together.
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.
Sorry, using this, do not give corect rsult, if M11:M13, is 0.
So, pls use This formula, just with Enter.
=IF(SUM(M11:M13) <1;0;SUM(K5-M14))
or maybe
=IF(COUNTA(M11:M13)=0,0,K5-SUM(M11:M13))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks