=IF(AND(F5+G5+I5+K5+M5+O5+Q5+S5=0,"",if(F5+G5+I5+K5+M5+O5+Q5+S5=F5),"OK"))
i want the result cell to show nothing if all cells added together = 0 and only show OK if they = the total given in cell F5
What am i doing wrong i get all OK or all "" regardless of what gets entered
Thanks
Last edited by mojobaabby; 08-16-2011 at 07:32 PM.
Try:
Please Login or Register to view this content.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
AND(F5+G5+I5+K5+M5+O5+Q5+S5=0
is wrong
if you just want to check the total=0
if(sum(F5,G5,I5,K5,M5,O5,Q5,S5)=0,"",if(sum(F5,G5,I5,K5,M5,O5,Q5,S5)=f5,"ok","something else"))
Last edited by martindwilson; 08-16-2011 at 07:27 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Got it thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks