Hi! How do I make it possible for the return of my formula to be not more than a specific number? Thanks!
Solved
Formula result should not be more than a specific number
Best answer by Kamille_Parks11
MIN(number, calculation)
^ number = the maximum number
^ calculation = whatever formula you have that returns a number
+27MIN(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?
+27FF: 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?
+27No, {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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.