View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default help needed in IF function

You have too many nested functions, so this approach cannot work.

Try

=VLOOKUP(E5,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,"
A-";95,"A"},2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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(E57
5,"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