#### darshanladdha

##### New Member

Can we have formula for this in Excel?

- Thread starter darshanladdha
- Start date

Can we have formula for this in Excel?

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?

Yes, I know there is no limit to solutions.There are infinitely many solutions...

How to get those infinite solutions?

@pecoflyerBy calculating until the end of times?

Not really to the end of time's,

I need it till 20000 atleast.

= SEQUENCE(5000, 1, Remainder, Divisor )

@Peter Bartholomew= Remainder + Divisor * SEQUENCE(5000, , 0 )

= SEQUENCE(5000, 1, Remainder, Divisor )

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.

is directly equivalent but needs to committed with

would do it.