Cell is either A or B

[adam1993]

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

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>

 

[shg]

	A​	B​	C​	D​	E​	F​
1​	Home	Away	$50​	TRUE​	Away	E1: =IF(OR(C1 = {75,100,125}) * D1, A1, IF((C1 = 50) * D1, B1, ""))
2​	Home	Away	$75​	TRUE​	Home
3​	Home	Away	$100​	TRUE​	Home
4​	Home	Away	$125​	TRUE​	Home

 

[adam1993]

	A​	B​	C​	D​	E​	F​
1​	Home	Away	$50​	TRUE​	Away	E1: =IF(OR(C1 = {75,100,125}) * D1, A1, IF((C1 = 50) * D1, B1, ""))
2​	Home	Away	$75​	TRUE​	Home
3​	Home	Away	$100​	TRUE​	Home
4​	Home	Away	$125​	TRUE​	Home

<tbody>
</tbody>

That gave me an error message :/ Maybe a better way of asking is... If D = True, if C is $50, then E= B but if D = True, C is either 75, 100 or 125 then E = A but if neither of the two are True then "-"

 

[shg]

The formula works on my end. You may have to modify to use the correct argument separator for your language settings.