CODEWITHSUNDEEP
mathexcel-formula
Mr.Smith
Mr.Smith

Reputation: 190

Reverse calculation of an existing formula

I have this formula

D5 = 10000
D4 = 9726.76

=SUM((D5 - D4) * ((1500 *1) / D4))

The results will be: 42.13736126

And I'm looking for way to provide the result and get the D5 (10000);

I hope this is understandable enough :)

Upvotes: 1

Views: 481

Answers (1)

I like Excel very much
I like Excel very much

Reputation: 748

I don't know what cell the 42.137 is in, but the formula is:

(Result*D4)/(1*1500)+D4

Upvotes: 2

Related Questions