Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP + IF STATEMENTS | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
2 If Statements between 2 values Q | Excel Worksheet Functions | |||
Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
If statements | Excel Worksheet Functions |