If and with multiple conditions & cells

[HAPLOID]

Novice Excel user trying to figure out an if and formula
[TABLE="width: 621"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]BR[/TD]
[TD]CLOCK[/TD]
[TD]$2[/TD]
[/TR]
[TR]
[TD]BR[/TD]
[TD]CLOCK[/TD]
[TD]$2[/TD]
[/TR]
[TR]
[TD]BR[/TD]
[TD]TABLE[/TD]
[TD]$5
[/TD]
[/TR]
[TR]
[TD]BR[/TD]
[TD]CHAIR[/TD]
[TD]$3[/TD]
[/TR]
[TR]
[TD]LV[/TD]
[TD]CLOCK[/TD]
[TD]$3[/TD]
[/TR]
[TR]
[TD]LV[/TD]
[TD]CLOCK[/TD]
[TD]$3[/TD]
[/TR]
[TR]
[TD]LV[/TD]
[TD]CLOCK[/TD]
[TD]$3[/TD]
[/TR]
[TR]
[TD]LV[/TD]
[TD]CLOCK[/TD]
[TD]$3[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Essentially I am trying to say if A1=BR and B1=clock then $2 should be the multiplier (didnt include that data)
the formula i wrote was : =SUM(D2*E2) * IF(AND(A2="BR",B2="CLOCK",2))) but I get and error. Not sure where my mistake is. Any help would be appreciated

 

[Mr Kulle]

Not sure if this is what you want :

=IF(AND(A1="BR",B2="CLOCK"),"2",
IF(AND(A1="BR",B2="TABLE"),"5",
IF(AND(A1="BR",B2="CHAIR"),"3",
"NOT DEFINED")))

 

[Mr Kulle]

sorry should be :
=IF(AND(A1="BR",B1="CLOCK"),"2",
IF(AND(A1="BR",B1="TABLE"),"5",
IF(AND(A1="BR",B1="CHAIR"),"3",
"NOT DEFINED")))

 

[HAPLOID]

Thank you! worked perfectly