View Single Post
  #4  
Old April 11th, 2010, 05:09 AM posted to microsoft.public.excel.newusers
Matthew[_16_]
external usenet poster
 
Posts: 2
Default Difference between real number and a perfect fractions

Sorry about the delayed response.

The denominator should not go over three significant digits, not be
greater than 100 so anything less than 100 will be fine i.e. 1-99
The formula is pretty simple For an exact 8:13 ratio, after 8 years,
Venus has made 13 revolutions.
Actual ratio is 0.61518624, so after 8 years, Venus has made
8/0.61518624 = 13.004192 revolutions or 13.004192 – 13 = 0.004192 *
360 = 1.5 degrees over the 8 years.

Is there a command that will return the numerator and denominator for
a selected value.. I was looking at the Quotient functions but I don’t
think that will work.