"Sandy Mann" wrote in message
...
Hi Tracey.

I think that it is impertinent to change someone else's formula but as
Daddy still does not seem to be around and with my apologies to Daddy,
try:

Insert a new Column B and enter the multiplier in it: 1 for no multiplier,
10 for x10 etc and 0.1 for divide by 10 etc.

Then change the formula to:

=MOD(LOOKUP(10^LEN(C2),D2:IV2)-LOOKUP(10^LEN(C2),D2:IV2,C2:IV2),10^LEN(C2))*B10

as before the *number* (or at least C2) must be text so that leading zeros
count as real characters

One caveat, if both figures are the same the formula will return zero and
if the first reading is smaller than the second it will return an error of
the capacity of the meter

Once again my apologies to Daddy

--
HTH

Can't get this to work sorry

:-(

Am I missing something ?

Should B10 be B2 ?

I changed that but still it didnt work.