Very simple - but i need help

Thanks:  0
Likes:  0

# Thread: Very simple - but i need help

1. ## Very simple - but i need help

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

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

2. ## Re: Very simple - but i need help

Try this.

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

3. ## Re: Very simple - but i need help

Thank you so much.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•