View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GarMcCas GarMcCas is offline
external usenet poster
 
Posts: 2
Default A correct formula gives an incorrect figure

I did find the error, there were numbers not showing, I went into options on
the tools area and checked calculations, and clicked precision as displayed

"GarMcCas" wrote:

In a payrol sheet I am adding a row of numbers calculating the amount paid in
one month. There are 4 numbers all ending in 1. the formula I used to
calculate is a very basic formula. It is =SUM(G10:G14). Instead of giving
me the last number as 4, it gives me a 5.