entering formulas

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

"If" formula help 7
If and Or Functions in Same Cell 4
Help with if then function 2
Copy formulas in defined range 4
How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi 2
Time Functions 2
If or 3
HELP!! Change formulas programmatically -- all I get is text! 7

Back
Top