ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   logic (IF) functions (https://www.excelbanter.com/excel-worksheet-functions/95539-logic-if-functions.html)

elaine

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"))))))))

Franz Verga

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



Bearacade

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


Nick Hodge

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




Ragdyer

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"))))))))




All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com