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.

Hi

Try putting double quotes around the text you are looking for

=IF('[ANCILLARY 2007.xls]0211-0224'!$E$4="9a-5p","ON","OFF")


--
Regards

Roger Govier


"waladd" wrote in message
...
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.

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

If the contents over in ANCILLARY is actually displayed as 9a-5p then just
enclose that portion of your formula in double-quotes also:
=IF('[ANCILLARY 2007.xls]0211-0224'!$E$4="9a-5p","ON","OFF")


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

Thank you guys.

"Dave Peterson" wrote:

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