Help with Excel formulas
 

I have entered a
formula,=IF((OR(E21="",C21="")),0,IF((E21<C21),((E 21-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?

Help with Excel formulas
 

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

Help with Excel formulas
 

Try:

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

Regards

Trevor


"Tara Martin" <Tara wrote in message
...
I have entered a
formula,=IF((OR(E21="",C21="")),0,IF((E21<C21),((E 21-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?

Help with Excel formulas
 

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


"Tara Martin" <Tara wrote in message
...
I have entered a
formula,=IF((OR(E21="",C21="")),0,IF((E21<C21),((E 21-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?