I want to calculate our daily goal based on the hours worked in a day. If we
are off that day, the goal is 0. My false value keeps coming up with the
text instead of a number.

=IF('2007 HRS'!B6="OFF",0,"=2007 HRS'!B6*'2007 HRS'!$E$44")