Help with Excel formulas

[Guest]

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?

 

[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

 

[Trevor Shuttleworth]

Try:

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

Regards

Trevor

 

[Peo Sjoblom]

Maybe something like

=IF(COUNT(,C21,E21,F21,I21)=0,"",MOD(E21-C21,1)*24+MOD(I21-F21,1)*24)



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com