If Formula in Excel

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

I need to use 11 IF sections to calculate grades....ie:
=IF(D2>97,"4",IF(D2>95,"3.7",IF(D2>93,"3.5",IF(D2>90,"3",IF(D2>87,"2.7".....etc,etc
What can I do????? This was just thrown in my lap this morning and I need it
ASAP. Please help....
 
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)
 
Back
Top