rob clement wrote:
Steve Hanson wrote:
in calc I am trying to do a simple formula like this g35-g36 when the
dollar value is the same it gives me a -.01 dollar valve. so
someplace it is adding 1 cent when it should be 0. Example
customers bill is 47.93 (g35) they paid 47.93 (g36) balance due (g37)
shows .01
Thanks for the help
Steve Hanson
[EMAIL PROTECTED]
Steve
Could I suggest that you make a change to the spreadsheet to display 3
decimal places on the g35 field. This can be done using the >Format
>Cells then the number tab and change the decimal places to 3. I think
the calculation of g35 results in an odd .001 at the end.
Please let us know the result.
Rob
This is a place where the ROUND function will work for you. Format is
=ROUND( X;Y ) where X is the number to be rounded, and Y is the number
of decimals to be displayed.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
