lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
hi
I have table like the one below. I calculate grade using if() function, a for >80, b for >70 etc. The I used countif() to find out how many a,b,c, and f, I have.
a = 1
b = 10
c = 3
f = 4
My question, I want excel to give me the percentage % of a, b, c, and f. so I want to have something like this
a = 7%
b = 40%
c= 33%
f=20%
Is that possible? Thank you so much
<tbody>
</tbody>
I have table like the one below. I calculate grade using if() function, a for >80, b for >70 etc. The I used countif() to find out how many a,b,c, and f, I have.
a = 1
b = 10
c = 3
f = 4
My question, I want excel to give me the percentage % of a, b, c, and f. so I want to have something like this
a = 7%
b = 40%
c= 33%
f=20%
Is that possible? Thank you so much
| name | mark | grade |
| john | 100 | a |
| mary | 70 | b |
| alex | 40 | f |
<tbody>
</tbody>
