| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding when referencing a cell with a formula?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
rounding when referencing a cell with a formula?
First I would use:
='Classified 08'!B5*1.05 Next make sure that the display format is not misleading you. -- Gary''s Student - gsnu200770 " 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
rounding when referencing a cell with a formula?
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
rounding when referencing a cell with a formula?
Thank you Gary...it didn't work.
"Gary''s Student" wrote: First I would use: ='Classified 08'!B5*1.05 Next make sure that the display format is not misleading you. -- Gary''s Student - gsnu200770 " 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
rounding when referencing a cell with a formula?
It's working? Thank you so much. You've made my day!
"Gary''s Student" wrote: First I would use: ='Classified 08'!B5*1.05 Next make sure that the display format is not misleading you. -- Gary''s Student - gsnu200770 " 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Referencing Cell Content | Excel Discussion (Misc queries) | |||
| #VALUE! displayed when referencing a formula cell | Excel Discussion (Misc queries) | |||
| need help referencing cell using result of formula | Excel Discussion (Misc queries) | |||
| Referencing text in a cell in a formula | Excel Discussion (Misc queries) | |||
| referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
Linear Mode
