# Formula result should not be more than a specific number

Topic Labels: Formulas
Solved
969 7
cancel
Showing results for
Did you mean:
4 - Data Explorer

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
16 - Uranus

`MIN(number, calculation)`

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

7 Replies 7
16 - Uranus

`MIN(number, calculation)`

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

4 - Data Explorer

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

4 - Data Explorer

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?

16 - Uranus

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

4 - Data Explorer

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

16 - Uranus

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.

4 - Data Explorer

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