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?

I played with that formula, and got the VALUE error when g90 or f90
contained a space, instead of being blank. If this is what's happening
for you, then your entry person needs to leave the cells blank instead
of entering a space.

Dave O

=IF(OR(G90={""," "},F90={""," "}),"",G90-F90+11)


"Phxlatinoboi®" wrote:

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?

awesome it worked.

thanks :-D

"Teethless mama" wrote:

=IF(OR(G90={""," "},F90={""," "}),"",G90-F90+11)


"Phxlatinoboi®" wrote:

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?