Thread
:
logic (IF) functions
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge
Posts: n/a
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
Reply With Quote