Posted to microsoft.public.excel.worksheet.functions
|
|
help needed in IF function
Hi
Have a look at this:
http://www.cpearson.com/excel/excelF.htm#Grades
It should help you to sort it out. The reason your formula is not working is
because you are only allowed 7 nested IFs.
Hope this helps!
Andy.
"DaredEvil590"
wrote in message
news:DaredEvil590.1z1tta_1132915803.4166@excelforu m-nospam.com...
HI everyone,,
I need to know what's wrong in this forumla:
=IF(E594,"A",IF(E589,"A-",IF(E585,"B+",IF(E582,"B",IF(E579,"B-",IF(E575,"C+",IF(E572,"C",IF(E569,"C-",IF(E559,"D",IF(E50,"F",))))))))))
==============
I need your help as soon as possible.
Thank you :)
--
DaredEvil590
------------------------------------------------------------------------
DaredEvil590's Profile:
http://www.excelforum.com/member.php...o&userid=29085
View this thread: http://www.excelforum.com/showthread...hreadid=488117
|