Hi Tracy,

If by Multiplier you mean it says on the meter " x 100 " then simply
multiply, (or divide as appropriate), the result of the formula by 100:

=MOD(D2-C2,10^LEN(D2))*100


--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Maria Tracey" wrote in message
...

"Sandy Mann" wrote in message
...
Tracy,

Daddy doesn't seem to be around a the moment. I would suggest making the
meter reading entries text by formatting the cells as text *before*
entering the reading or preceding them with an apostrophe if they are
already entered, (so that the leading zeros will be counted as
characters), then using Daddy's excellent formula, modify it to:

=MOD(D2-C2,10^LEN(D2))


Thanks, I'll give it a try.

What about the multipliers and dividers ?
Any idea how to tackle that ?