software

Just set up a basic data sheet where I show a product cost, then beneath that
it calculates what 25% of that cost is, then beneath that its supposed to
calculate product cost less the calculated 25% rate. However, its rounding
the 25% discount figure up but rounds the product cost less discount figure
down. So its a penny out. Any suggestions, coz Im having to manually adjust
each time !!!

Thanks in advance.

On Tue, 4 Apr 2006 07:34:02 -0700, Big Bad Nige lt;Big Bad
gt; wrote:

gt;Just set up a basic data sheet where I show a product cost, then beneath that
gt;it calculates what 25% of that cost is, then beneath that its supposed to
gt;calculate product cost less the calculated 25% rate. However, its rounding
gt;the 25% discount figure up but rounds the product cost less discount figure
gt;down. So its a penny out. Any suggestions, coz Im having to manually adjust
gt;each time !!!
gt;
gt;Thanks in advance.

When you say rounding do you really mean the numbers are rounded with
=ROUND(), or that's the way it's formatted to displayIt sounds like you have the cells formatted to show no decimal places,
(or at least one dec. pl. less than the product cost).
Try rounding the 25% calculation.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

I've solved it now, I read somewhere else in this forum:
Tools/Options/Calculations then click on quot;Precision As Displayedquot;.

Thanks all the same Richard, and thanks to however wrote that thread answer.

quot;Richard Buttreyquot; wrote:

gt; On Tue, 4 Apr 2006 07:34:02 -0700, Big Bad Nige lt;Big Bad
gt; gt; wrote:
gt;
gt; gt;Just set up a basic data sheet where I show a product cost, then beneath that
gt; gt;it calculates what 25% of that cost is, then beneath that its supposed to
gt; gt;calculate product cost less the calculated 25% rate. However, its rounding
gt; gt;the 25% discount figure up but rounds the product cost less discount figure
gt; gt;down. So its a penny out. Any suggestions, coz Im having to manually adjust
gt; gt;each time !!!
gt; gt;
gt; gt;Thanks in advance.
gt;
gt; When you say rounding do you really mean the numbers are rounded with
gt; =ROUND(), or that's the way it's formatted to display
gt;
gt;
gt; It sounds like you have the cells formatted to show no decimal places,
gt; (or at least one dec. pl. less than the product cost).
gt; Try rounding the 25% calculation.
gt;
gt; HTH
gt;
gt; __
gt; Richard Buttrey
gt; Grappenhall, Cheshire, UK
gt; __________________________
gt;