Need help evaluating two pairs or four cells for empty values

[guy69]

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)

[simarui]

...

Please Login or Register  to view this content.

?

[guy69]

thanks for your help but that isnt going to work

the idea is i need to pair the empty cell tests... so as long as c/b isnt empty.. its ok to calculate that pair... the same goes for d/e... your formula tests all of the cells for blank values... the reason i need to pair test the cells is because there may be some instances where b/c will have values and d/e wont..

if this helps we can require b/c to have values before d/e calculation is considered... because the user will always enter a b/c value before they enter an d/e value on this worksheet.... any other ideas?

[guy69]

something like this.. if i could use two or statements.. but this isnt valid

=IF(OR(ISBLANK(C1),ISBLANK(B1)OR(ISBLANK(E1),ISBLANK(D1)),TIME(0,0,0),SUM(C1-B1))

[simarui]

how about:

Please Login or Register  to view this content.