| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DAverage Function help needed | Excel Worksheet Functions | |||
| Desperate Help needed with a function. | Excel Worksheet Functions | |||
| function needed | Excel Worksheet Functions | |||
| IF function help needed | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
