Simple calculation doesn't auto-calculate HELP!

[Bigragu]

I have a simple excel sheet to calculate the adjacent dimensions from an angle and the hypotenuse. Then I what to divide the hypotenuse by the adjacent to get a simple ratio, but it only works if I delete both inputs and reenter them. This is probably a simple problem that I just can't see, thanks for any help.

[Pete_UK]

You have this formula in B3:

=B1*COS(RADIANS(B2))

and this one in B4:

=B1/B3

which is effectively the same as:

=B1/(B1*COS(RADIANS(B2)))

or:

=1/COS(RADIANS(B2))

So, the ratio in B4 does not depend on what you have entered in B1 - it only depends on the value you enter into B2.

Hope this helps.

Pete