cancel
Showing results for
Search instead for
Did you mean:
Advocate I

## How to return the quotient of a division?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
4 REPLIES 4
Super User

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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Helper II

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!

Advocate I

@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.

Advocate I

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

## Helpful resources

Announcements

#### Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

#### Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,259)