Classification Using Lookup function

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!

Read more on this article...

Check if Value is Present in the give RANGE

Creating a formula that will return TRUE if each number in column E appears at least once in the range A2:C6.

If any of the specified numbers are missing, the formula will return FALSE.

Solution: Use AND and COUNTIF functions in the following Array formula:{=AND(COUNTIF(A2:C6,E2:E10))}

Read more on this article...