LinkBack URL
About LinkBacks
Hello,
This formula only returns the right answer when SUM(I5:I72)=100% and I get a #NAME? error for any other result. Column I contains blank cells.
=IF(SUM(I5:I72)=100%,"Correct!",IF(SUM(I5:I72)=O%,"Correct!","Error!"))
Thanks!
Patrick
Hello,
This formula only returns the right answer when SUM(I5:I72)=100% and I get a #NAME? error for any other result. Column I contains blank cells.
=IF(SUM(I5:I72)=100%,"Correct!",IF(SUM(I5:I72)=O%,"Correct!","Error!"))
Thanks!
Patrick
You have O% rather than 0%. Letter O rather than number zero.
BSB
Try this instead:
=IF(SUM(I5:I72)=100%,"Correct!",IF(SUM(I5:I72)=0%,"Correct!","Error!"))
Can you see the difference?
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Gheez, I sure missed that....using the letter o instead of the number 0!
Thanks much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks