Limit return value
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
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
So simple and worked perfectly. Thanks!
-
Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.