Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

FORMULAS (SUMIF?)

Options

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.

 

 

Untitled.png

Tags:

Comments

  • Jason Rowe
    Options

    Roxanne,

    Try something like this

    =IF(SUM([Price46-Price45) > 0.1, 0.1, IF(SUM(Price46-Price45) < 0.1, SUM(Price46-Price45)))

    I think this might work. (Sorry if it doesn't) And for eight percent just substitute all of the 0.1 with 0.08.

This discussion has been closed.