Use data validation to select a cell in a formula

[Memar]

[FONT=&quot]I use a data validation to select YES or NO. When YES is selected, I want a number of product to be multiplied by the number in cell A1. When NO is selected, I want the number of product to be multiplied by the number in B1.
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]

2 (number in cell A1)

3 (number in cell B1)

<tbody class="SCXW137062123" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">
</tbody>

[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]

Products	Select Yes or No from the drop down menu	Quantity		Desired result
Computer	YES	10	=10*A1	20
Mouse	YES	5	=5*2	10
Keyboard	NO	13	=13*3	39
Monitor	YES	20	=20*2	40

<tbody class="SCXW137062123" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">
</tbody>

[/FONT]
[FONT=&quot]
[/FONT]

 

[Yongle]

With value to be multiplied in C2 and yes/no in B2

=(B2="Yes")*C2*$A$1+((B2)="No")*C2*$B$1

A1 and B1 are absolute references (use of $)