RAJESH NATH
Board Regular
- Joined
- May 19, 2020
- Messages
- 55
- Office Version
- 365
- Platform
- Windows
I have below sheet, and I need result as mention below where I used if formula only. Is there any other way to solve it. |
a | b | c | d | e | result |
1 | b | ||||
3 | a | ||||
2 | c | ||||
1 | d | ||||
4 | e | ||||
5 | c |
=IF(A9>0,"a",IF(B9>0,"b",IF(C9>0,"c",IF(D9>0,"d",IF(E9>0,"e")))))