Results 1 to 3 of 3

creating a formula that skips empty cells

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2007
    Posts
    3

    creating a formula that skips empty cells

    im doing a meter reading on a daily basis but on weekends and sometimes during the week i dont do the reading. my problem is with the day following the missed read my calc is wrong. column c is the meter reading and column d is the usage. i get column d by subtracting the previous meter read from the current one (=IF(C9>0,C9-C8,0). my problem is after a non read day the usage ends up being the meter read. i need a formula that will search up column c until it finds a numerical figure to subract against the new read.
    thanks
    turbo90talon
    Last edited by turbo90talon; 10-19-2007 at 03:30 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1