# Thread: Meter reading spreadsheet

1. I am doing a spreadsheet of meter readings. I need a formula that will not allow a negative number but rather roll over to 0's. For example, if a reading one month is 9999 and the next month the reading is 0028 since the meter itself has rolled over, I need to be able to show that in the cell that reflects the usage for the month. Hope I've explained this clearly enough. Thanks.

2. Originally Posted by Sandy Levin
I am doing a spreadsheet of meter readings. I need a formula that will not allow a negative number but rather roll over to 0's. For example, if a reading one month is 9999 and the next month the reading is 0028 since the meter itself has rolled over, I need to be able to show that in the cell that reflects the usage for the month. Hope I've explained this clearly enough. Thanks.
Start meter reading in A1
End meter reading in B1

Useage =if(B1<A1,B1+(10000-A1),B1-A1)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•