Y/N know is there a way to ratio rows or columns.
What is this way?
My unsuccessful attempts at circular referencing to 3 cells & down the 3
columns were not achievable.

Goal/Example.
What I attempting is to have a ladder against a wall the dimensions of the
height and distance from the wall will always be proportional to Pythagoras
law 3:4:5 in columns C:D:E, However they must be variable at the same time
and then the result of said calc is to be able to be used in another cell for
another calc?

Hi,

Lets assume you enter a number in c1 (say) 3.

Put this formula in D1
=C1/3*4
and this in E1
=D1/4*5

the 3 numbers will now be in the ratio 3/4/5 and can be tested as being with
the formula in another cell

=C1^2+D1^2=E1^2
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Busnpleasur" wrote:

Y/N know is there a way to ratio rows or columns.
What is this way?
My unsuccessful attempts at circular referencing to 3 cells & down the 3
columns were not achievable.

Goal/Example.
What I attempting is to have a ladder against a wall the dimensions of the
height and distance from the wall will always be proportional to Pythagoras
law 3:4:5 in columns C:D:E, However they must be variable at the same time
and then the result of said calc is to be able to be used in another cell for
another calc?