Many times I came across MS Excel sheet where people use IF Then to classify grades. IF then is really big and confusing in this kind of scenarios. I would suggest you to use LOOKUP function to
1 The scenario is to classify values into Fail, Second Class, First Class, Distinction and Merit.
2. Refer to formula in the image.
3. This is an easy alternative to IF formula.
Formula : =LOOKUP(A2,{0,35,45,60,75,90,100},{"Fail","Pass Class","Second Class","First Class","Distinction","Merit"})
Also, do let me know your comments about this post and subscribe to us to receive latest updates via email
We assure you knowledge, not SPAM!
8 comments:
hey good one sarfaraz... plz do keep up yo posts..
Excellent Sarfaraz, Thanks for sharing this info. Keep updating such type of formulas.
Regards
Balu
Hi Sarfara, thanks for the post. You are taking off a big chunk of trouble from us by these posts/ Thanks a tonne once again, keep on posting. wish you all the best
Sourojit
good yaar........
thnx for d post..
plz dost keep up yr post....
Formula : =LOOKUP(A2,{1000,3000,4000,6000,7000,9000,10000},{a2*50%,a2*40%,a3*30%,a2*25%,a2*20%,a2*10%})
when i written this .....
than its not working.......
y plz sol my query...
=LOOKUP(A2,{1000,3000,4000,6000,7000,9000,10000},{a2*50%,a2*40%,a3*30%,a2*25%,a2*20%,a2*10%})
is not correct.
As you cant use formula in resulting vector. You will have to provide string.
I am sure you can precalculate those values and provide in last brace bracket.
Good Serfaraz, Very good,
My All best wishes with u
Good one sir,
Keep going...
Post a Comment