Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
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. |