Number Rollover

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
 
B

Bob Phillips

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)
 
J

John Wilson

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
 
Top