excel formula

A

Ammar

the following formula can not add more arguments to it :=IF
(B4>79.99,"A",IF(B4>74.99,"A-",IF(B4>69.99,"B+",IF
(B4>64.99,"B",IF(B4>59.99,"B-",IF(B4>54.99,"C+",IF
(B4>49.99,"C",IF(B4>44.99,"C-","D"))))))))

I would like to add the values of D+, D, D-, E & F
can I get assistance on this.
Thanking you
Ammar
 
B

Bob I

You may only nest 7 If statmente. Please read the information contained
in HELP for the "IF" worksheet function.
 

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

Top