Excel,problem with if function

Solved/Closed
soni17177
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012
- Oct 16, 2012 at 01:49 PM
soni17177
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012
- Oct 17, 2012 at 02:32 PM
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

aquarelle
Posts
7115
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 2, 2022
491
Oct 16, 2012 at 03:28 PM
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
0
soni17177
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012

Oct 16, 2012 at 03:40 PM
above given formula also showing A for alphabatic cell having value AB
0
aquarelle
Posts
7115
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 2, 2022
491
Oct 16, 2012 at 04:13 PM
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"))))))
0
soni17177
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012

Oct 17, 2012 at 02:32 PM
thanks a lot
0