LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Rounding Effecting Sum

I have cells that cotain formulas based on adding four other cells together.
One of those cells is the result of a percentage applied to a dollar amount.
While it only displays 2 decimal places when looking at it, the formula seems
to recognize that there are more. This is interfering with the total in one
of my columns. The dollar amounts don't add up correctly because the sum is
adding decimal places I am not seeing.

So. How do we shave off those places so the formula doesn't see them?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting one column effecting the whole sheet. A Excel Discussion (Misc queries) 2 February 25th 09 10:35 AM
new row without effecting equations NJK Excel Discussion (Misc queries) 1 July 15th 08 06:43 PM
Insert rows without effecting formulas [email protected] Excel Worksheet Functions 1 September 10th 07 08:53 AM
Profile effecting Excel Spike Excel Discussion (Misc queries) 2 November 23rd 05 05:18 PM
Text to Column effecting automatically Hari Excel Discussion (Misc queries) 6 June 2nd 05 09:54 AM


All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"