Hi,
I am needing some help in determining which formula to use to lookup a value and then run a calculation. I am trying to populate the value in my spreadsheet in column R.
I am trying to calculate commission split which the percentage is based off of a text value. I have the commission amount in Column R of my spreadsheet.
For the text condition, For Example if A2 equals Expedia I am wanting to multiply the value in Column S2 by .90. If A2 equals Orbitz I am wanting to multiply the value in Column S2 by .80
Thanks in advance for someone's help with this.
Hi Nick,
Try this
=IF(A2="Expedia", S2*0.9, IF(A2="Orbitz", S2*0.8))
If neither of these conditions are met then the formula will return False.
If you need more help, please supply your workbook.
Regards
Phil
