Forum Discussion
Solved
Formula assistance
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 t...
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
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