Thread: Excel problem
View Single Post
  #1 (permalink)  
Old 16-04-08, 07:52 PM
colinicky colinicky is offline
Driving my truck with my high-heels on...
  

Join Date: Sep 2004
Location: SE
Posts: 2,827
colinicky is a scuba diver - warm watercolinicky is a scuba diver - warm watercolinicky is a scuba diver - warm watercolinicky is a scuba diver - warm watercolinicky is a scuba diver - warm watercolinicky is a scuba diver - warm watercolinicky is a scuba diver - warm watercolinicky is a scuba diver - warm watercolinicky is a scuba diver - warm watercolinicky is a scuba diver - warm watercolinicky is a scuba diver - warm water
Excel problem
I have a spread sheet for accounting but have a little problem in that the totals at the bottom of 3 columns do not add up to the total of the columns They are out by a penny which is driving my mother ( & hence me ) insane . I think it has to do with the vat in that each entry is worked to 2 decimal places ( & rounded accordingly ) but I think the spread sheat is adding them all up to the zillionth decimal place & then rounding the total .How can I stop this & get it to just add the figures that are on display ?
__________________
Colin

I trust my rebreather completely ,
I just don't trust the user

onwards & downwards
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote