Try this.
=D2*IF(OR(B2="Wilma",B2="Betty"),100,50)
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
Try this.
=D2*IF(OR(B2="Wilma",B2="Betty"),100,50)
If posting code please use code tags.
Thank you so much.
Like this thread? Share it with others