Forum Discussion
dmadden
Feb 19, 2020Copper Contributor
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...
- Feb 19, 2020
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
Feb 19, 2020MVP
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
- dmaddenFeb 20, 2020Copper Contributor
Yes, this is exactly what I was looking for! Now that I see the formula it makes perfect sense. Thank you for your help!!
- Alan_MurrayFeb 20, 2020MVP
Awesome dmadden