IF function

  • Thread starter Thread starter MB HEG
  • Start date Start date
M

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")
 
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
 
hi
remove the double quotes.
=IF(2007 HRS!B6="OFF",0,2007 HRS'!B6*2007 HRS!$E$44)

regards
FSt1
 
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.
 
If I want to also test the words "CE", "ML", "SICK" along with "off" how can
I add that to the formula
 
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
 
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
 
Back
Top