lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want do check student marks and based on the value I will make excel to type a,b,c,d,f.
If >80 then A, if >70 then B etc. I can do that using nested if. But lets say I have 10 conditions, is there better way to do that? if function will be complicated. I wonder if there is something easier. Thank you.
I want do check student marks and based on the value I will make excel to type a,b,c,d,f.
If >80 then A, if >70 then B etc. I can do that using nested if. But lets say I have 10 conditions, is there better way to do that? if function will be complicated. I wonder if there is something easier. Thank you.