Previous Topic Next Topic

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

Answer 1 / 3
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
Answer 2 / 3
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
Answer 3 / 3
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"))))))
Report
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012
thanks a lot
Ask a question