MrExcel Publishing
Your One Stop for Excel Tips & Solutions

computer vs calculator


Posted by Jim on August 08, 2001 2:24 PM

Figuring the diagonal of the run and rise,w/computer:
C11 = 9", the rise
K14 = 9 1/2" the run
O14 = 11 1/4" the diagonal
on a calculator with the same input the diagonal
= 13 1/16" any ideas what i'm doing wrong
Thanks,Jim


Posted by Barrie Davidson on August 08, 2001 2:27 PM

Jim, what is the calculation for "the diagonal of the run"?

Barrie

Posted by Mark W. on August 08, 2001 2:34 PM

=(rise^2+run^2)^.5

...produces 13.0862523283024 or 13 1/16

Posted by Mark W. on August 08, 2001 2:39 PM

See Pythagorean theorem

C^2=A^2+B^2

Posted by Barrie Davidson on August 08, 2001 2:40 PM

Mark, I've got to ask....

How did you know this???

Posted by Jim on August 08, 2001 2:44 PM

C11 = 9"
C9 = C11/12", Ans. =(0.7500)
H9 = 12"
E9 = Sqrt(C11^2+H9^2)/12", Ans. =(1.2500)
C2 = Sqrt(C11^2+H9^2)/12"*C11, Ans. = 11 1/4"

Posted by Mark W. on August 08, 2001 2:46 PM

Re: Mark, I've got to ask....

Geometry... I loved it!

Posted by Mark W. on August 08, 2001 2:49 PM

You've gone too far! All you need is...

=SQRT(rise^2+run^2)

Posted by Jim on August 08, 2001 2:53 PM

Mark W: Very intelligent!

Posted by The European Contingent on August 09, 2001 12:03 AM

GO METRIC - ITS EASIER ON THE EYES

:

Posted by Mark W. on August 09, 2001 7:04 AM

Re: GO METRIC - ITS EASIER ON THE EYES

Yeah, it's only fair. We should use metric if
you buy McDonald's 113.398077437203 "gram-er".