IF function

[MB HEG]

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")

 

[Pete_UK]

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

 

[FSt1]

hi
remove the double quotes.
=IF(2007 HRS!B6="OFF",0,2007 HRS'!B6*2007 HRS!$E$44)

regards
FSt1

 

[MB HEG]

Thank you that works perfect. I tried taking the quotes out, but it kept
putting them back in. I just copied and pasted yours and it works great.

 

[MB HEG]

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

 

[FSt1]

hi
just string the ifs togeather upto 7 for 2003 and lower
IF(2007 HRS!B6="OFF","off",IF(2007 HRS!B6="Sick","Sick",IF(2007
HRS!B6="ce","ce",if(2007 HRS!B6="ml","ml",2007 HRS'!B6*2007 HRS!$E$44))))

regards
FSt1

 

[Max]

Another way, as responsed in your other post:
=IF(ISNUMBER(MATCH('2007 HRS'!B12,{"OFF";"CE";"ML";"VAC"},0)),0,'2007
HRS'!B12*'2007 HRS'!$E$44)
Extend to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik

 

[Dave Peterson]

Check your other post.

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