Help with Excel formulas

[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?

[[email protected]]

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


"Tara Martin" <Tara [email protected]> wrote in message
news:[email protected]...
>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?

[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


"Tara Martin" <Tara [email protected]> wrote in message
news:[email protected]...
>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?