Formula

[Guest]

I have a column that accepts dates (8/14/07). some of the cells don't have
any dates cause there is no need. I am trying to use an if statement
referring to this column to perform a mathematical function. what i have is
=IF(C7=C6,SUM(Z7-Z6),""). If works fine but when both cells are blank it
returns a time of 0:00 and i want it to return a blank cell, the same as it
would if it was false. i've tried AND and OR and cannot figure out how to do
it correctly. Can someone help me?

The Z cells are formatted for time as is the cell the result is going into.

 

[David Biddulph]

=IF(OR(C7<>C6,AND(C6="",C7="")),"",Z7-Z6)

Remember that the SUM() function doesn't do anything for you if you give it
only one argument.
SUM(Z7-Z6) is as pointless as PRODUCT(Z7-Z6) or AVERAGE(Z7-Z6) or
MINIMUM(Z7-Z6) or MAXIMUM(Z7-Z6) or ...