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.

Name		Units	Earnings
Betty		2
Betty		7
Betty		4
Fred		6
Barney		9
Wilma		5
Barney		12
Fred		3

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Norie]

Try this.

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

 

[mrobin69]

Thank you so much.