Results 1 to 5 of 5

Need help evaluating two pairs or four cells for empty values

Threaded View

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Somewhere
    MS-Off Ver
    Excel 2003
    Posts
    3

    Need help evaluating two pairs or four cells for empty values

    greetings from another world. i need help putting together this excel formula.

    i want to test four cells for empty values but this evaluation must be performed in pairs. i am subtracting the values of each pair and then adding the difference. the formula i have works for the first cell pair but i do not understand how i can include a second test for e1/d1. the idea is that i dont want excel to perform the calculation if (b1/c1) or (d1/e1) are blank. any help you can provide would be appreciated. thank you.

    =IF(OR(ISBLANK(C1),ISBLANK(B1)),TIME(0,0,0),SUM(E1-D1)+SUM(C1-B1)
    Last edited by guy69; 09-20-2012 at 10:06 AM.

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