If 9a-5p is text that's in the cell, try wrapping it in double quotes:

...$e$4="9a-5p", ...



waladd wrote:

I'm trying to create a formula to read data from one spreadsheet and return
conditional results. I figured the IF function was best but I cannot get it
to work. I am trying to change data such as 9a-5p, 8a-4p, 6a-2p, to ON, so
the false would return OFF. Here is what I've tried as an actual formula:
=IF('[ANCILLARY
2007.xls]0211-0224'!$E$4=9a-5p,"ON","OFF")

I've tried it with and without the = before 9a-5p, it tries to correct it to
a9-p5.
Any help would be greatly appreciated, I am using Office 2003 Pro.

--

Dave Peterson