If formula - multiple test

Giganews Newsgroups
Subject: If formula - multiple test
Posted by:  MB HEG
Date: Thu, 31 Jul 2008

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

Replies