Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
In a nut shell I am looking to display the margin of error from a
perfect fraction. So I can determine if a orbit is is too close to being in perfect resonance and hence unstable. 0.61518624 = Current real value = 1,922,457 / 3,125,000 0.615384615 = Exactly 8/13 two significant denominator digits. 0.032% <= difference express as a percentage. Anything in the denominator 100 is statistical irrelevant how can i get an excel cell to do this automatically? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sort number with fractions | New Users to Excel | |||
How tp display fractions / custom number | Excel Worksheet Functions | |||
Whole number from fractions | Excel Worksheet Functions | |||
real number | Excel Discussion (Misc queries) | |||
How do I round up fractions to the next whole number? | Excel Worksheet Functions |