Formula

U

ucastores

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.
 
D

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 ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top