I want to test the value in a cell and return a value if it's "yes", another
if it's"no" and yet another if null in a cell on another worksheet.
I tried using IF but couldn't get it to work - I'm sure I'm missing
something really simple but can't put my finger on it!!!

Help.

Thanks

Hi there Dave Eade,

I used two workbooks named "test1.xls" and "test2.xls"
In test1.xls i used the number 1 in cell A1 and the number 2 in cell A2. In
test2.xls i used the number 3 in cell A1

I placed the formula in test1.xls in cell C2.
Formula is :
=IF(A2=1,"YES",IF(B2=2,"YES",IF([test2.xls]Sheet1!$A$2=3,"YES","NO")))

Works fine for me. You can tweak it to suit your needs

Let us know if this works for you

Regards

Garreth

--

Thank you and Regards

Garreth Lombard


"Dave Eade" wrote:

I want to test the value in a cell and return a value if it's "yes", another
if it's"no" and yet another if null in a cell on another worksheet.
I tried using IF but couldn't get it to work - I'm sure I'm missing
something really simple but can't put my finger on it!!!

Help.

Thanks