"Sandy Mann" wrote in message
...
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


That's great thanks.

I'd love to be able to combine that with Daddylonglegs formula which works
out the last reading

=MOD(LOOKUP(100000,C2:IV2)-LOOKUP(100000,C2:IV2,B2:IU2),100000)


Is that possible ?

Thank You