With your condition

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"

the formula would be
=IF(A1="OK","N",IF(A1="Y","Y",""))

of if you need to return whatever in A1 then use
=IF(A1="OK","N",A1)


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

1. For you first question refer HELP on functions; or refer the below site

http://www.excelfunctions.net/

2. Use the IF condition

=IF(A1="OK","Y","N")
OR
=IF(A1="OK","Y",IF(A1="Y","N",""))

If this post helps click Yes
---------------
Jacob Skaria


"andy" wrote:

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