Help Finding (Difficult?) Formula

Josh_Smith505 

Refer to the following image:

If E1 = D1/B1 should equal E2, then with simple algebra, the formula in D1 should be =B1*E2.

And if D1 = A1*C1, then with simple algebra, the formula in A1 should be =D1/C1.

But note that A1 is not $425, and D1 is not $5100.

-----

OTOH, if A1 should be rounded down to a multiple of 5 (wild guess; you need to specify why you expect $425), then perhaps the formula in A1 should be =FLOOR(B1*E2/C1, 5), and the formula in D1 can be =A1*C1, as specified originally.

That results in the following:

But note that E1 cannot be exactly the goal in E2.  (But for this example, it does round to E2.)

-----

Alternatively, if D1 should be rounded to a multiple of $100 (again, a wild guess; you need to specify), then the formula in D1 should be =MROUND(B1*E2, 100), and the formula in A1 might be =D1/C1 again.

That results in the following again:

But note that again E1 cannot be exactly the goal in E2.