Roger that. Small thing: If you define your breakpoints as 89, 79, ..., as I have in my example, rather than 90, 80, etc., then your inequalities in the formula can be strict ">" rather than of the...
 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
Search:
Type: Posts; User: ArcSine
Search: Search took 0.01 seconds.
-
Jun 12, 2019, 05:16 AM
Question: Convert numerical grade to letter grade in Excel
by ArcSine- Answers
- 3
- Views
- 5,587
Roger that. Small thing: If you define your...
-
Jun 11, 2019, 12:53 PM
Question: Convert numerical grade to letter grade in Excel
by ArcSine- Answers
- 3
- Views
- 5,587
You can. Excel's IF() operates like C's (if this...
You can. Excel's IF() operates like C's (if this ? then this : otherwise this). Taking advantage of the left-to-right processing of the nested IFs:
=IF(D3 > 89, "A", IF(D3 > 79, "B", IF(D3 > 69,...
Results 1 to 2 of 2
|
