I searched, but couldn't find a solution to obtain the quotient of a division.
The Excel related function would be QUOTIENT(). PowerApps doesn't have it, it only has MOD().
How could I return the quotient of a division?
Solved! Go to Solution.
The Quotient formula in Excel only returns an integer of the division, so the equivalent would be:
RoundDown(numerator/denominator, 0)
I hope this is helpful for you.
The Quotient formula in Excel only returns an integer of the division, so the equivalent would be:
RoundDown(numerator/denominator, 0)
I hope this is helpful for you.
First off I should mention I have no knowledge of Excel, so I'm unfamiliar with the quotient-function that's used there. But since the quotient is the 'answer' of the division, I wonder what you're trying to do, because getting this answer is straightforward.
When dividing 6 by 3, the quotient is 2. So if you set the X-value (just one of many possible examples) of a control to
6 / 3
the X-coordinate will be the quotient (2). If this was set on a label control, getting the quotient could be done by referencing Label1.X
Setting a variable with the quotient of whatever you're dividing works the same:
Set( varQuotient, Dividend / Divisor)
But maybe I'm not understanding correctly. If so, please elaborate on what you want to achieve.
Hope it helped!
@jblomberg Thank you, this is what I am trying to achieve link
I need to divide the total gallery items / increment (25) , and display in a dropdown box 25, 50, 75, 100, up to the total gallery items.
@RandyHayes wrote:The Quotient formula in Excel only returns an integer of the division, so the equivalent would be:
RoundDown(numerator/denominator, 0)
I hope this is helpful for you.
@RandyHayes That's what I was looking for, many thanks!