workbook/cell reference w/ formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
If 9a-5p is text that's in the cell, try wrapping it in double quotes:

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


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.
Click to expand...
 
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")
 
Thank you guys.

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

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


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.
Click to expand...
Click to expand...
 
Back
Top