Thread: Desire Sum to add visible figures rather than underlying decimals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerry Jerry is offline
external usenet poster
  
Posts: 142
Default Desire Sum to add visible figures rather than underlying decimals
I have a column of decimals which, through formating, I ask that only the
whole number be visible. The "Sum" function is adding the underlying
decimals rather than the visible whole numbers. ie; 2.4 + 2.4 = 4.8 (rounded
to 5) however I would like 2.4 (rounded to 2) + 2.4 (rounded to 2) to equal
4. How do I make that happen?
Thanks for any input
--
Jerry
Reply With QuoteReply With Quote