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.
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
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>