logic statement

A

andy

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
 
J

Jacob Skaria

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"
Click to expand...

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
 
Top