Formula for 4 slabs of %

[Ajinkya]

Hi,


I want to segregate percentages into four slabs like as,

0-70=A

71-80=B

81-90=C

91-100=D


Tried to sorted out but...,pls suggest formula for the same.

 

[Shaun]

Hi Ajinkya,


A possible soultion could be:


=IF(A1>100,"",IF(A1>90,"D",IF(A1>80,"C",IF(A1>70,"B",IF(A1="","","A")))))


I am sure those more skilled in Excel will have a much more elegant way to solve your issue, but this works.


I am not sure, but you may need to tweak the percentage limits depending on cell formatting, but this should get you on the right track.


Cheers


Shaun

 

[Ajinkya]

Hi Shaun,


Result is coming "A" for all criteria....


Meanwhile, i have used =IF(A2<70%,"A",IF(A2<80%,"B",IF(A2>90%,"D","C")))


Its working


Cheers

 

[Faseeh]

Hi Shaun,


Very well done!! You can also solve it using vlookup, but you have to create a table-like thing:

[pre]

Start   End    Grade
0       70     A
71      80     B
81      90     C
91      100    D[/pre]

Use....  =VLOOKUP(Lookup_Value,Lookup_Table,3)

I believe this is more flexible way of doing this.


Regards,

Faseeh