View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default incorrect calculation

Be more specific about what you have. A row doesn't calculate anything, a
formula does. What are the formulas you have? In what cells/columns? What
are in the other columns? Check the formats in the cells of the various
columns. A cell that is formatted as text will display a number if a number
is entered into it, but in fact Excel will take that number as text. Any
subsequent calculations with that "number" will not be correct. HTH Otto
"Markies" wrote in message
...
In the workbook I use for electric meter readings one of the months one
row
doesn't calculate correctly. I cannot figure out why. The rest of the
workbook calculates the way it should. This particular row is about $45
off
what the total should be. Anyone know how I can fix this?