Hi,Some help please. I've looked at LOOKUPs, IF, ANDs and I can't seem to figure out the correct formula to use.
Column A contains a half year score and Column B contains a full year score, Column C is the 'reference' for the final year score.
I'm looking for a formula/way for excel to return the Final Result.
Hope this makes sense
<tbody>
</tbody>There are 15 rows in total.
Thanks in advance for your help
Column A contains a half year score and Column B contains a full year score, Column C is the 'reference' for the final year score.
I'm looking for a formula/way for excel to return the Final Result.
Hope this makes sense
HY Score | FY Score | Final result |
1 | 1 | 1 |
1 | 2 | 2 |
1 | 3 | 2 |
2 | 1 | 1 |
2 | 2 | 2 |
2 | 3 | 2 |
<tbody>
</tbody>
Thanks in advance for your help