Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 05, 10:45 AM posted to microsoft.public.excel.worksheet.functions
DaredEvil590
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=488117


  #2   Report Post  
Old November 25th 05, 11:00 AM posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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[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
View this thread: http://www.excelforum.com/showthread...hreadid=488117



  #3   Report Post  
Old November 25th 05, 11:32 AM 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[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
View this thread: http://www.excelforum.com/showthread...hreadid=488117



  #4   Report Post  
Old November 25th 05, 01:02 PM posted to microsoft.public.excel.worksheet.functions
DaredEvil590
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=488117

  #5   Report Post  
Old November 25th 05, 02:27 PM posted to microsoft.public.excel.worksheet.functions
DaredEvil590
 
Posts: n/a
Default 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.

please help me to solve this problem, soon.


thank you very much


--
DaredEvil590
------------------------------------------------------------------------
DaredEvil590's Profile: http://www.excelforum.com/member.php...o&userid=29085
View this thread: http://www.excelforum.com/showthread...hreadid=488117



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DAverage Function help needed xrayr Excel Worksheet Functions 3 July 26th 05 04:09 PM
Desperate Help needed with a function. Lori Excel Worksheet Functions 3 July 21st 05 03:19 AM
function needed David Harrison Excel Worksheet Functions 1 February 23rd 05 11:28 PM
IF function help needed jmcclain Excel Worksheet Functions 2 February 23rd 05 04:33 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017