Give evryone a penny rise to 32.40 otherwise I don't believe that it will
ever work out.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Steve" wrote in message
ink.net...
Hello,

I have a spreadsheet for calculating labor rate. Column A contains tenths
of an hour (.1, .2, .3 etc...) Column B has a simple formula (=A1*32.39),
and is filled down. Column B is formatted to currency, and 2 decimal
places (which I need to maintain). When I look at, for example .3, the
result is $9.72. Then I look at .6, and the result is $19.43. If you
multiply $9.72 by 2, the result is $19.44, 1 penny off from the
spreadsheet. I have tried some rounding functions, but the results were
still off like this. Any suggestions?

Thanks,
-Steve