Limit return value

Jessica Abbey
Jessica Abbey ✭✭
edited 05/03/21 in Smartsheet Basics

Is there a way to limit a number returned in a formula? I have a simple formula that returns a percentage (for a completion rate), but I don't want it to show over 100% or it will mess up my averages when used elsewhere. So even if someone over performs, their completion rate should only still show 100%


Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hi @Jessica Abbey ,

    Add an IF statement to your formula.

    =IF( /formula/ >1,1, /formula/)

    If your formula is greater than 1 (100%) it returns 100% otherwise it returns the result of your formula.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.