Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
logic (IF) functions
I have the following function that I am using to replace letter grades with
grade points. Excel will not allow me to enter more than seven nested functions. Is there another way? =IF(D3="a","4",IF(D3="b+","3.5", IF(D3="b","3",IF(D3="c+","2.5",IF(D3="C","2",IF(D3 ="D+","1.5",IF(D3="D","1",IF(D3="F","0")))))))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
logic (IF) functions
Nel post
*elaine* ha scritto: I have the following function that I am using to replace letter grades with grade points. Excel will not allow me to enter more than seven nested functions. Is there another way? =IF(D3="a","4",IF(D3="b+","3.5", IF(D3="b","3",IF(D3="c+","2.5",IF(D3="C","2",IF(D3 ="D+","1.5",IF(D3="D","1",IF(D3="F","0")))))))) Till Excel 2003 there's a limit of 7 level of nested functions. You can solve using a table and the VLOOKUP function. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
logic (IF) functions
Or if you insist of doing a long if statement, try to following: =IF(LEFT(E9,1)="a",4,IF(LEFT(E9,1)="b",3,IF(LEFT(E 9,1)="c",2,IF(LEFT(E9,1)="d",1,IF(LEFT(E9,1)="f"," 0","OUT OF RANGE"))))) & IF(RIGHT(E9,1)="+",".5","") HTH -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=554680 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
logic (IF) functions
Franz
Petty, but it's until XL2007, in case anyone tries more in XL2003 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Franz Verga" wrote in message ... Nel post *elaine* ha scritto: I have the following function that I am using to replace letter grades with grade points. Excel will not allow me to enter more than seven nested functions. Is there another way? =IF(D3="a","4",IF(D3="b+","3.5", IF(D3="b","3",IF(D3="c+","2.5",IF(D3="C","2",IF(D3 ="D+","1.5",IF(D3="D","1",IF(D3="F","0")))))))) Till Excel 2003 there's a limit of 7 level of nested functions. You can solve using a table and the VLOOKUP function. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
logic (IF) functions
You could try this:
=LOOKUP(D3,{"A","B","B+","C","C+","D","D+","F";4,3 ,3.5,2,2.5,1,1.5,0}) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "elaine" wrote in message ... I have the following function that I am using to replace letter grades with grade points. Excel will not allow me to enter more than seven nested functions. Is there another way? =IF(D3="a","4",IF(D3="b+","3.5", IF(D3="b","3",IF(D3="c+","2.5",IF(D3="C","2",IF(D3 ="D+","1.5",IF(D3="D","1",IF(D3="F","0")))))))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Logic question | Excel Discussion (Misc queries) | |||
AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
Need help setting up a formula using perhaps the logic functions . | Excel Worksheet Functions |