Meter reading spreadsheet

Topic

New Reply

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.

Reply | Quote

Replies

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)

Reply | Quote