Skip to main content

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

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 ! <3

MIN(number, calculation)


^ number = the maximum number

^ calculation = whatever formula you have that returns a number


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?

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?

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


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

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.

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.

Reply


Terms & Conditions