Thread: If Statements
View Single Post
  #1   Report Post  
NEWNEW
 
Posts: n/a
Default If Statements

I need to include more than 7 functions in an "IF" statement. It's so
simple, but I can't figure it out. What I need pertains to grades. In a
hidden column, I have basically "IF" A is entered, return 4; If B is entered,
return 3, etc., down to "F." However, I now need to include Honor Class
grades (A=4.5, B=3.5, C=2.5, and D=1.5). A, B, C, D, F, AH, BH, CH, DH --
that's 9. CAN ANYONE HELP ME!!??

THANK YOU