# Finding Dividend with Remainder and Divisor only.

##### New Member
Can we have formula for this in Excel?

#### pecoflyer

##### Active Member
Please be a little more explicit.
A workbook perhaps?

##### New Member
Let me give an example.

I have Remainder = 2 & Divisor = 4. I need a formula or function in Excel which will find the value of Dividend. Quotient not available.

P. S. : We have MOD function in Excel which gives remainder value.
MOD(6,4) = 2
I want inverse MOD function for finding the value of x, which is Dividend.
MOD(x,4) = 2

Please be a little more explicit.
A workbook perhaps?

#### pecoflyer

##### Active Member
There are infinitely many solutions...

##### New Member
There are infinitely many solutions...
Yes, I know there is no limit to solutions.
How to get those infinite solutions?

#### pecoflyer

##### Active Member
By calculating until the end of times?

#### Peter Bartholomew

##### Well-Known Member
= Remainder + Divisor * SEQUENCE(5000, , 0 )
= SEQUENCE(5000, 1, Remainder, Divisor )

##### New Member
= Remainder + Divisor * SEQUENCE(5000, , 0 )
= SEQUENCE(5000, 1, Remainder, Divisor )
@Peter Bartholomew
Thanks much,
But Which one I should use?
1st one is not generating any results for me.
Can you please post an excel sheet copy for 1st one?
Sorry for the disturbance though.

#### Peter Bartholomew

##### Well-Known Member
The SEQUENCE function is only available using Microsoft 365. The first form is easier to emulate with legacy Excel.
= Remainder + Divisor * (ROW(1:5000)-1)
is directly equivalent but needs to committed with Ctrl+Shift+Enter. If you enjoy relative referencing and fill down then
= Remainder + Divisor * (ROW()-2)
would do it.