Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formula result should not be more than a specific number

Topic Labels: Formulas
Solved
Jump to Solution
414 7
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi! How do I make it possible for the return of my formula to be not more than a specific number? Thanks!

1 Solution

Accepted Solutions

MIN(number, calculation)

^ number = the maximum number
^ calculation = whatever formula you have that returns a number

See Solution in Thread

7 Replies 7

MIN(number, calculation)

^ number = the maximum number
^ calculation = whatever formula you have that returns a number

Yay, it works! Thank you so much @Kamille_Parks ! ❤️

FF: So I’m using this formula: MIN(10,{Work Days}-{Absences}) but it doesn’t seem to perform {Work Days}-{Absences} when I’m putting a value on Absences HUHU
What do you guys think?

Are both {Work Days} and {Absences} numbers?

No, {Work Days} is a formula and {Absences} is number.

Okay, but does {Work Days} return a number? If the values in the column are aligned to the left the answer is no, if the values in the column are aligned to the right the answer is yes.

Yes, it does return a number and the values in the column are aligned to the right.