rounding when referencing a cell with a formula?

[lyndaw]

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.

 

[Gary''s Student]

First I would use:

='Classified 08'!B5*1.05

Next make sure that the display format is not misleading you.

 

[Gord Dibben]

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

 

[lyndaw]

Thank you Gary...it didn't work.

First I would use:

='Classified 08'!B5*1.05

Next make sure that the display format is not misleading you.

 

[lyndaw]

Thank Gord good info

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

 

[lyndaw]

It's working? Thank you so much. You've made my day!