Column C1= $125, $100 or $75 AND D1 = TRUE then this cell = A1, if not then it is blank. But also if column C1 = $50 and D1 = TRUE then this cell = B1.
Not sure how to get this formula to work
<tbody>
</tbody>
Not sure how to get this formula to work
Away | Home | $50 | TRUE | Home |
Away | Home | $75 | TRUE | Away |
Away | Home | $100 | TRUE | Away |
Away | Home | $125 | TRUE | Away |
Away | Home | $100 | FALSE | - |
<tbody>
</tbody>