Re: [AFMUG] OT Excel oddness

Bill Prince Thu, 30 May 2019 12:21:37 -0700

You need to set the rounding precision. Read about it here.

bp
<part15sbs{at}gmail{dot}com>

On 5/30/2019 12:17 PM, Lewis Bergman wrote:

Yeah. I run into this when I do tower leases that run out to a lot of years and have annual increases. Normally it flies through fine but every once in a while someone will check and mention that every so often it is off by the rounding (dispalyed rounding). I just agree to whatever pennies they want and go on but it is annoying.

On Thu, May 30, 2019 at 11:58 AM <[email protected]> wrote:

If you divide a number like $123.45 by 2 you get $61.73 if the format of the first cell is set to two decimal points of precision.

Fine, obeys rounding rules.

Now if you take the cell containing $61.73 and multiply it by 3 you get $185.18

If you take your calculator out and do that same calculation you get $185.19

Even if you set precision format to 2 decimal places, it continues to carry full floating point precision in the cell, irrespective of how it is displayed.

There is an option under options>advanced for setting precision as displayed.

But that will shut off full floating point calculations.

Seems like they would have a third option for financial formats only.

--
AF mailing list
[email protected]
http://af.afmug.com/mailman/listinfo/af_af.afmug.com

--

Lewis Bergman
325-439-0533 Cell

-- 
AF mailing list
[email protected]
http://af.afmug.com/mailman/listinfo/af_af.afmug.com

Re: [AFMUG] OT Excel oddness

Reply via email to