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....