April 27, 2021
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.
October 5, 2010