Finding Dividend with Remainder and Divisor only.

[darshanladdha]

Can we have formula for this in Excel?

 

[pecoflyer]

Please be a little more explicit.
A workbook perhaps?

 

[darshanladdha]

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]

There are infinitely many solutions...

 

[darshanladdha]

There are infinitely many solutions...

Yes, I know there is no limit to solutions.
How to get those infinite solutions?

 

[pecoflyer]

By calculating until the end of times?

 

[darshanladdha]

By calculating until the end of times?

@pecoflyer
Not really to the end of time's,
I need it till 20000 atleast.

 

[Peter Bartholomew]

= Remainder + Divisor * SEQUENCE(5000, , 0 )
= SEQUENCE(5000, 1, Remainder, Divisor )

 

[darshanladdha]

= 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]

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.