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>
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Not sure how to get this formula to work
Home | Away | $50 | True | Away |
Home | Away | $75 | True | Home |
Home | Away | $100 | True | Home |
Home | Away | $125 | True | Home |
<tbody>
</tbody>
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>