If I want to also test the words "CE", "ML", "SICK" along with "off" how can
I add that to the formula

"Pete_UK" wrote:

That's because you put it inside quotes. Try it this way:

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

Hope this helps.

Pete

On Aug 1, 1:50 am, MB HEG wrote:
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")