using type accounting to 2 decimal places, gives me the above 761.90... but
when i type it in a single cell (=28.22 x 27) i get the correct answer 761.94
when still using accounting type to 2 decimal places...........why is this
using type accounting to 2 decimal places, gives me the above 761.90... but
when i type it in a single cell (=28.22 x 27) i get the correct answer 761.94
when still using accounting type to 2 decimal places...........why is this
rob
Depends upon the underlying value of the cells that contain the formatted
28.22 and 27.
If I have a cell with 28.2188 formatted as Accounting it shows 28.22
Another cell with 26.998123 formatted as Accounting it shows 27.00
Sum of the two cells is 761.85
Read the info here at John McGimpsey's site.
http://www.mcgimpsey.com/excel/pennyoff.html
Gord Dibben Excel MVP
On Tue, 20 Sep 2005 13:20:03 -0700, rob <[email protected]> wrote:
>using type accounting to 2 decimal places, gives me the above 761.90... but
>when i type it in a single cell (=28.22 x 27) i get the correct answer 761.94
>when still using accounting type to 2 decimal places...........why is this
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks