Previous Topic Next Topic

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

Answer 1 / 3
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
Answer 2 / 3
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
Answer 3 / 3
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