Ratio ??.
in [Programming]
|
From: Busnpleasur on 1 May 2010 08:30 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?
From: Mike H on 1 May 2010 08:38 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? >
|
Pages: 1 Prev: Freeze the Title in Excel Next: Help with Regexp, please |