The formula in in G14 of the attached spreadsheet, shows calculation result of D13 (1921.80) divided by G12 (3.7) equalling 517.407692307695. This is incorrect, it should be 519.405405405. It's driving me crazy! How do I fix this?
The formula in in G14 of the attached spreadsheet, shows calculation result of D13 (1921.80) divided by G12 (3.7) equalling 517.407692307695. This is incorrect, it should be 519.405405405. It's driving me crazy! How do I fix this?
it a rounding error....G12 is not really 3.7....its 3.7142857 and when you do the 10 key you probably just did 3.7
try this=IF(G12=0,0,D13/ROUND(G12,1))
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
*worked! Bless you!
glad it worked....dont' forget to mark this thread has solved....check the forum rules on how to do that....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks