Help with Excel formulas

T

Tara Martin

I have entered a
formula,=IF((OR(E21="",C21="")),0,IF((E21<C21),((E21-C21)*24)+24,(E21-C21)*24))+IF((OR(I21="",F21="")),0,IF((I21<F21),((I21-F21)*24)+24,(I21-F21)*24))
in timecards but I would like it to leave cell blank if there are no
enteries,how do I do this?
 
J

jtarmin

Add IF(CELL="","",ELSE).. I am not sure what cell you want look at, if
there is multiple then add this for each cell..

I think this is what you want

IF(OR(E21="",C21=""),"",IF((E21<C21),((E21-C21)*24)+24,(E21-C21)-24))

this is only the first part
 
T

Trevor Shuttleworth

Try:

=IF(AND(E21="",C21=""),"",your formula without the leading equals sign)

Regards

Trevor
 
Top