AND and OR statements are usually used as part of a condition or to
return a true of false. You are better using if statements

they take the basic for If(true,this,otherwise that)

To cope with more than 2 outcomes they can be nested

=IF(B1=1,IF(A1="yes","A","R"),"")

If B1=1 and A1=yes then A
If B1=1 and A1 is not yes (the only other option is no) return R
If B1 does not equal 1 return blank


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=507126