 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008rounding 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. First I would use: ='Classified 08'!B5*1.05 Next make sure that the display format is not misleading you.  SignatureGary''s Student - gsnu200770 > 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. Thank you Gary...it didn't work. > First I would use: > [quoted text clipped - 6 lines] > > 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. It's working? Thank you so much. You've made my day! > First I would use: > [quoted text clipped - 6 lines] > > 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. 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 >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. Thank Gord good info > Have a read at John McGimpsey's site about why your sum is out a peny. > [quoted text clipped - 6 lines] > >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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.