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
Related:

3 responses

Answer 1 / 3
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 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 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses