SOLVED

Formula assistance

Copper Contributor

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!

3 Replies
best response confirmed by dmadden (Copper Contributor)
Solution

Hi @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

@Alan Murray 

 

Yes, this is exactly what I was looking for! Now that I see the formula it makes perfect sense. Thank you for your help!!

Awesome @dmadden 

1 best response

Accepted Solutions
best response confirmed by dmadden (Copper Contributor)
Solution

Hi @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

View solution in original post