Excel,problem with if function

[Solved/Closed]
Report
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012
-
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012
-
Hello,


i am working with excell with follwing formula-
=IF(H33>=75,"A",IF(H33>=60,"B",IF(H33>=45,"C",IF(H33>=33,"D",IF(H33>=0,"E",IF(H33=AB,"E"))))))
above formula is working properly with numeric values 0 to 100,but if the cell having a alphabatic value"AB" than this formula showing there "A" whenever i want to show there "E".
please heip me to correct it.
thank you

3 replies

Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
488
Hi,

Try this :
=IF(H33>=75,"A",IF(H33>=60,"B",IF(H33>=45,"C",IF(H33>=33,"D",IF(H33>=0,"E",IF(H33="AB","E"))))))

Best regards
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012

above given formula also showing A for alphabatic cell having value AB
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
488
And like that ?
=IF(H33="AB","E",IF(H33>=75,"A",IF(H33>=60,"B",IF(H33>=45,"C",IF(H33>=33,"D",IF(H33>=0,"E"))))))
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012

thanks a lot