Formula result should not be more than a specific number

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

MIN(number, calculation)

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

2 Likes

Yay, it works! Thank you so much @Kamille_Parks ! <3

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.

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.