I'm working on a sheet that will help us with lots of data. This spreadsheet has 2 work sheets in it, one is being used as a form, the other data.

I'm having trouble with a formula on a "Form" worksheet that tells me - if a cell on the "Data" worksheet is blank, then leave it blank. If it contains the word "ON", then put an "X" in the cell.

Here's what I am using to try and get this working, not having any luck.
Any ideas?

=IF(OR('Data'!H2="",'Data'!H2=ON),””, X)

Thanx...LT