entering formulas

G

Guest

I have entered the formula
=IF((OR(E35="",C35="")),0,IF((E35<C35),((E35-C35)*24)+24,(E35-C35)*24))+IF((OR(I35="",F35="")),0,IF((I35<F35),((I35-F35)*24)+24,(I35-F35)*24)),
but I cannot figure out how to show my cell blank if there is no information
in it....Please help
 
G

Guest

What do you mean "show my cell blank if there is no information in it"

By the way, I think that this formula is shorter and clearer like this

=IF((OR(E35="",C35="")),0,(E35-C35)*24+IF(E35<C35,24,0))+IF((OR(I35="",F35="")),0,(I35-F35)*24+IF((I35<F35),24,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top