|
SW WI | google
excel water meter usage template
excel water meter
excel water meter roll over
There are tutuorials
https://answers.microsoft.com/en-us/msoffice/forum/all/meter-reading...
use a if statement
Assuming reading 1 is in A1 and reading 2 is in B1.
=if(B1>A1,B1-A1,10000-A1+B1)
When the second reading is greater than the first, normal subtraction. If the second reading is "less" than the first 10000-A1+B1. | |
|
Excel Question
