Thread
:
rounding when referencing a cell with a formula?
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
Posts: 4
rounding when referencing a cell with a formula?
Thank Gord good info
"Gord Dibben" wrote:
Have a read at John McGimpsey's site about why your sum is out a peny.
http://www.mcgimpsey.com/excel/pennyoff.html
Gord Dibben MS Excel MVP
On Wed, 27 Feb 2008 16:10:01 -0800,
wrote:
I have set up a worksheet and need to add .5% to each cell. I am using the
formula ='Classified 08'!B5+('Classified 08'!B5*.5%) in each cell and out of
180 cells 30 are off by .01 some over some under. Any ideas why this is
happening? Out of 180 cells 30 are off by .01.
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]