LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erick T.
 
Posts: n/a
Default how to minimize rounding error with complicated formulas

(I'm running Excel for Mac 2004.)

I have a series of three functions, each of which is calculated separately
in its own cell. Then, in a fourth cell, I calculate the product of those
three cells. I'll call this the "building block approach".

I've tried to replicate that with a single calculation, "one-stop shopping",
as it were. However, the new answer differs very slightly from the old one.

The calculations involved are (in addition to the addition, subtraction,
multiplication, and division) are TINV and SQRT.

I'm wondering which method is giving me the more accurate answer, the
"building block" or the "one-stop shopping" method. I assume this is due to
rounding error. Any idea which of these two methods is more or less likely to
cause this problem.

(BTW, "Precision as Displayed" is NOT checked in Preferences.)

Thanks for any help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated Formulas Andy (Hypnotic_Monkey_Scratcher) Excel Worksheet Functions 7 August 28th 05 08:40 PM
Rounding Formulas Chandra Excel Discussion (Misc queries) 5 July 5th 05 05:18 PM
rounding a formula's number [email protected] Excel Worksheet Functions 2 March 9th 05 07:33 PM
formulas for rounding Mas Excel Discussion (Misc queries) 1 February 10th 05 06:46 PM
specific rounding of formulas which may need to include an IF stat Gerry Wilkins Excel Worksheet Functions 2 January 5th 05 04:11 AM


All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"