Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2010
    Location
    Arizona
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by Sandy Levin View Post
    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
  •