If Formula in Excel
 

I need to use 11 IF sections to calculate grades....ie:
=IF(D297,"4",IF(D295,"3.7",IF(D293,"3.5",IF(D2 90,"3",IF(D287,"2.7".....etc,etc
What can I do????? This was just thrown in my lap this morning and I need it
ASAP. Please help....

If Formula in Excel
 

Use a VLOOKUP table or CHOOSE. Look in the help index for both

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cindy" wrote in message
...
I need to use 11 IF sections to calculate grades....ie:
=IF(D297,"4",IF(D295,"3.7",IF(D293,"3.5",IF(D2 90,"3",IF(D287,"2.7".....etc,etc
What can I do????? This was just thrown in my lap this morning and I need
it
ASAP. Please help....

If Formula in Excel
 

Hi Cindy
create a table, column A 97,95 etc
Column B 4,3.7,3
Then in E2 enter the formula as follos
=SUMPRODUCT(--(A1:A15=D2),B1:B15)

"Cindy" wrote:

I need to use 11 IF sections to calculate grades....ie:
=IF(D297,"4",IF(D295,"3.7",IF(D293,"3.5",IF(D2 90,"3",IF(D287,"2.7".....etc,etc
What can I do????? This was just thrown in my lap this morning and I need it
ASAP. Please help....