View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phxlatinoboi® Phxlatinoboi® is offline
external usenet poster
 
Posts: 16
Default Formula Question

I am using the following formula to sum up how many hours a person is
scheduled to work: =IF(OR(G90="",F90=""),"",G90-F90+11). But if someone has
no hours it comes up with "VALUE". I would like it to be blank. How would I
do that?