Limit return value

Jessica Abbey

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%

Mark Cronk

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.

Work?

Mark

Mark Cronk

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.

Work?

Mark

Jessica Abbey

So simple and worked perfectly. Thanks!

Mark Cronk

Glad you found a solution. Thank you for contributing to the Community.

Mark