Hope someone can help, as i am not too good at functions (Is there a book
with examples in??)

i would like to know a statement that will allow 1 answer cell to have two
conditions from two seperate work books.
if 1 work book cell is eg "OK" then one answer would be "N"
if the other work book cell was "y" then the answer would be "Y"

Only one cell either OK or Y would be populated. the other would be blank.

Regards

Andy