Number Rollover

  • Thread starter Thread starter CMarkou
  • Start date Start date
C

CMarkou

I have a worksheet for each day of the month that I am inputting the
current days Meter numbers in, then I have a cell the calculates the
sales from the previous and current days meters. When the meter rolls
over 6 digits it starts over. The problem is that my sheet does not
recognize the roll over and shows a negative number. Is there a way to
have it recognize the rollover?

Chris
 
Chris,

I guess that you mean the subtraction is the problem. Assuming the previous
reading is in A1 and this is in B1, use something like

=B1-A1+(B1<A1)*1000000

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
CMarkou,

Not sure how you have your sheet set up but I'm assuming
that the meter can't "roll over" twice in a single day.
If this is true, then you've already recognized the roll over
because you now have a negative number.
Why not test for it and calculate acordingly.
=IF(result>0,originalformula,newformulatocompensate)

John
 
Back
Top