Excel,problem with if function
Solved/Closed
soni17177
soni17177
- Posts
- 10
- Registration date
- Wednesday October 10, 2012
- Status
- Member
- Last seen
- October 22, 2012
soni17177
- Posts
- 10
- Registration date
- Wednesday October 10, 2012
- Status
- Member
- Last seen
- October 22, 2012
Related:
- Excel,problem with if function
- Excel function @ symbol ✓ - Forum - Excel
- Excel function if cell contains text ✓ - Forum - Excel
- Excel Functions IF, AND, OR, and NOT - How-To - Excel
- Excel functions in French - Guide
- Excel function number to words - Guide
3 replies
aquarelle
Oct 16, 2012 at 03:28 PM
- Posts
- 7115
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- June 2, 2022
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
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
soni17177
Oct 16, 2012 at 03:40 PM
- 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
aquarelle
Oct 16, 2012 at 04:13 PM
- Posts
- 7115
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- June 2, 2022
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"))))))
=IF(H33="AB","E",IF(H33>=75,"A",IF(H33>=60,"B",IF(H33>=45,"C",IF(H33>=33,"D",IF(H33>=0,"E"))))))
soni17177
Oct 17, 2012 at 02:32 PM
- 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