I have a task line 'Total Commission Percentage Earned to Rep'. As you can see, right now it says 10.03%. I need a formula that max's that percentage out at 10%. Sometimes the 10% will change to 8% ('Commission Percentage Allowed to Rep') and that will need to max out at 8% as well (the other 2% would go to 'Commission Percentage Allowed to T/O Tech')...... =SUMIF()??? (by the way, the column with the percentages is 'Price'). Right now my formula is =SUM(Price46-Price45), but tha does not enable me to max out at 10% or 8%. If the 8%/10% thing is too complicated, I would appreciate help just on the 10% max formula. Thanks for the help.
