Help

Formula result should not be more than a specific number

Topic Labels: Formulas
Solved
Jump to Solution
1912 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Wing_PH
4 - Data Explorer
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
Kamille_Parks
16 - Uranus
16 - Uranus

MIN(number, calculation)

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

See Solution in Thread

7 Replies 7
Kamille_Parks
16 - Uranus
16 - Uranus

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.