I am not sure where I am mistake
I want to grade our daily sales
Formula on C10 for 63% performance should read GOOD , mine is reading BAD
I am not sure where I am mistake
I want to grade our daily sales
Formula on C10 for 63% performance should read GOOD , mine is reading BAD
Try,
=LOOKUP(C9,{0,42,61,81,99}%,{"BAD","NOT TOO BAD","GOOD","EXCELLENT","AWESOME"})
Awesome , wow this is even better than if
What was wrong on my if formula ?
You put them in the wrong order - worst to best. In the opposite order, best to worst it would have been OK. Also, they are %s, so 90% should have been 0.9
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Can someone than do the syntax please
The IF formula should read
=IF(C9<41%,"BAD",IF(C9<61%,"NOT TOO BAD ",IF(C9<81%,"GOOD",IF(C9<99%,"EXCELLENT","AWESOME"))))
I prefer the LOOKUP() though
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks