If formula - multiple test

[MB HEG]

I want use multiple discriptions in my spreadsheat to indicate when a
individual is off. How do I add this into my formula. I have the "off" in
there now and it works fine. However, I want to add the text "CE", "ML",
"VAC" to equal 0.

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

thanks

 

[Max]

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

 

[Dave Peterson]

Another one:

=IF(OR('2007 hrs'!B12={"OFF","CE","ML","VAC"}),0,
'2007 hrs'!B12*'2007 hrs'!$E$44)