Multiple Calculations in a Formula

[Guest]

I need help with how to properly create a formula for the following:
E
7 660
8 535
9 91
10 573

I will use E7 and E8 as an example:
E7/12=50 then 420/50=8.4
E8/12=44.58 then 420/44.58=9.42

12 and 420 are constants. Essentially, I will be using the answer of the
first calculation of the formula in the second calculation of the formula. I
hope this is clear. Thanks in advance

 

[Biff]

Try this:

=420/(E7/12)

Copy down.

E7/12=50 then 420/50=8.4

The actual result should be 7.63636363636364

Biff

 

[Guest]

THanks! Worked like a charm!!!

Try this:

=420/(E7/12)

Copy down.


The actual result should be 7.63636363636364

Biff