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....
 
Use a VLOOKUP table or CHOOSE. Look in the help index for both
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing GPA to Ltr Grade 8
excel not recognising numbers containing 0.1calculated by formulas 4
0.1 to 0.99 not recognised or calculated when results from formula 7
Logical if more than 7 4
IF LEN formula 4
Formula 1
If Statement based on blank fields 3
Help regarding 'IF' function in Excel 10

Back
Top