Formula result should not be more than a specific number

[Wing_PH]

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

[Kamille_Parks · Accepted solution]

MIN(number, calculation)

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

[Wing_PH]

Kamille_Parks:

MIN(number, calculation)

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

[Wing_PH]

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?

[Kamille_Parks]

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

[Wing_PH]

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

[Kamille_Parks]

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.

[Wing_PH]

Kamille_Parks:

values in the column are aligned to the left the answer is no

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