Good point regarding the quotes. I tried both ways with no luck. I think
maybe I didn't apply the formula correctly or what I am looking for is not
specific enough. I created another post called called Making Blank Cells, I
think its more specific regarding what I am trying to do;I think it will
probably be easier to figure out to. Thanks for your feedback.
Ed


"Pete_UK" wrote:

Try this:

=IF(OR(Sheet1!A4="11",Sheet1!A4="12"),H4,"")

Are you sure you mean "11" and "12" (in quotes) rather than just 11
and 12 ?

Hope this helps.

Pete

On Feb 4, 10:00 am, Workbook
wrote:
Right now I have the formula =IF(Sheet1!A4="11",H4,""). I want to include
"12" in this formula so that if "11" or "12" is in cell A4 the contents of
cell H4 will appear in the cell where this formula resides. Any thoughts?