Feb 19 2020 09:48 AM
I'm looking for assistance on a formula for my company's commission worksheet. I can't figure out how to get a sum of a total for a sales amount but if that sum exceeds 10% of the sales amount then that sum would be maxed at 10% of the sales amount. I've attached the spreadsheet I'm working on. G15 is my sum of G7:G13 but if that sum exceeds 10% of the sum of E7:E13 then the max sum for G15 would be that 10% of the sale amount (E7:E13). Thank you for your help!
Feb 19 2020 01:41 PM
SolutionHi @dmadden Please find the file attached.
You didn't mention what to d if it didn't exceed 10% of E7:E13. So I decided to show the value of the total of G7:G13.
I hope this helps.
Alan
Feb 20 2020 05:14 AM
Yes, this is exactly what I was looking for! Now that I see the formula it makes perfect sense. Thank you for your help!!
Feb 19 2020 01:41 PM
SolutionHi @dmadden Please find the file attached.
You didn't mention what to d if it didn't exceed 10% of E7:E13. So I decided to show the value of the total of G7:G13.
I hope this helps.
Alan