Very simple - but i need help

[mrobin69]

I am trying to get an IF OR function to work. Can I please get the formula from someone ? My head hurts....

I have a spreadsheet -

Column B has names in it - Fred, Barney, Wilma, Betty and many others, these names appear in random order down the column. In Column E I need to calculate the earnings. And in Column D is the total units sold. Wilma & Betty earn $100 per unit, every other name earns $50 per unit. I need the formula to calculate the earnings correctly for each name. thanks in advance.

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64"]Name[/TD]
[TD="width: 64"][/TD]
[TD="class: xl64, width: 64"]Units[/TD]
[TD="class: xl64, width: 64"]Earnings[/TD]
[/TR]
[TR]
[TD]Betty[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Betty[/TD]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Betty[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barney[/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wilma[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barney[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Norie]

Try this.

=D2*IF(OR(B2="Wilma",B2="Betty"),100,50)

 

[mrobin69]

Thank you so much.