I have a complex formula i need to create to look up various fields, with percentages of totals to be given if certain criteria are met, and need some guidance.
In column P i have a monetary figure. In column D i have a business deal type, New Business, Renewal or Upsell. In column T i have some Inside Sales users (some are blank depending if they assisted)
If a deal is New Business or Upsell I need to work out the % of the monetary figure. (renewals excluded).
If the deal has an Inside Sale usernames i need to calculate 3% of the monetary figure), however if the deal doesn't have an inside Sales user assigned i need to calculate 2% of the monetary figure.
If anyone can assist i would be very grateful!