On Monday 21 January 2008 14:44:01 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]
I can not duplicate your problem. My result is $0.00. Even when I expand the number of places, I still get the same result. The only difference is the number of zeros after the decimal point. My guess is that G35 and G36 are calculations as well. And because of the additional calculations, the difference between the values in these cells is greater than 0.5 of a cent. That is why you see the difference as $0.01. If you want the difference to be $0.00, you will have to modify the formulas in G35 and G36. Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
