Hi all,
This is my first time asking question online for excel(mostly just google and have the answer)
but i struggle to think of a good way to ask this question on google.
Basically I am making a cell at E2(shown below) to show subject 1 OR A2
<tbody>
</tbody>
I struggle to use if function with more than 2 cases, hopefully someone can assist me.
Thank you in advance
This is my first time asking question online for excel(mostly just google and have the answer)
but i struggle to think of a good way to ask this question on google.
Basically I am making a cell at E2(shown below) to show subject 1 OR A2
A | B | C | D | E | |
1 | subject 1 | subject 2 | subject 3 | X | X |
2 | 10 | 5 | 1 | =max(A1:C1) | ?? |
<tbody>
</tbody>
I struggle to use if function with more than 2 cases, hopefully someone can assist me.
Thank you in advance