Remember Me?

#1
November 25th 05, 10:45 AM posted to microsoft.public.excel.worksheet.functions
 DaredEvil590 Posts: n/a
help needed in IF function

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

#2
November 25th 05, 11:00 AM posted to microsoft.public.excel.worksheet.functions
 Posts: n/a
help needed in IF function

Hi

Have a look at this:

because you are only allowed 7 nested IFs.

Hope this helps!
Andy.

"DaredEvil590"
wrote in message
news[email protected] 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

#3
November 25th 05, 11:32 AM posted to microsoft.public.excel.worksheet.functions
 Bob Phillips Posts: n/a
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[email protected] 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

#4
November 25th 05, 01:02 PM posted to microsoft.public.excel.worksheet.functions
 DaredEvil590 Posts: n/a
help needed in IF function

thanks guys for ur help

it really worked.

thanks

--
DaredEvil590
------------------------------------------------------------------------
DaredEvil590's Profile: http://www.excelforum.com/member.php...o&userid=29085

#5
November 25th 05, 02:27 PM posted to microsoft.public.excel.worksheet.functions
 DaredEvil590 Posts: n/a
help needed in IF function

Hi Bob Phillips,

I used the formula that you gave it to me

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

everything is okay, but the problem is when I insert a grade between(
90-95) which suppose to get me ( A-) i got an error.

thank you very much

--
DaredEvil590
------------------------------------------------------------------------
DaredEvil590's Profile: http://www.excelforum.com/member.php...o&userid=29085

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post xrayr Excel Worksheet Functions 3 July 26th 05 04:09 PM Lori Excel Worksheet Functions 3 July 21st 05 03:19 AM David Harrison Excel Worksheet Functions 1 February 23rd 05 11:28 PM jmcclain Excel Worksheet Functions 2 February 23rd 05 04:33 PM Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM

All times are GMT +1. The time now is 04:13 AM.