Not sure how to compile the formula to make this happen:

If cell A1 is TRUE then cell A3 =€�X€�, or if cell A2 is TRUE then cell A3=€�Y€�
if both cells A1 and A2 are FALSE then cell A3="Z"

Any help would be appreciated.

=IF(A1,"X",IF(A2,"Y","Z"))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"tracktor" wrote in message
...
Not sure how to compile the formula to make this happen:

If cell A1 is TRUE then cell A3 ="X", or if cell A2 is TRUE then cell A3="Y"
if both cells A1 and A2 are FALSE then cell A3="Z"

Any help would be appreciated.

Tracktor,

The following equation put in cell A3 works,

=IF(A1=TRUE,"X",IF(A2=TRUE,"Y","Z"))

With the following in cells A1 and A2

=AND(B1=C1)
=AND(B2=C2)

where B1=C1 etc can be changed to whatever condition you are evaluating.


Ian Grega

"tracktor" wrote:

Not sure how to compile the formula to make this happen:

If cell A1 is TRUE then cell A3 =€�X€�, or if cell A2 is TRUE then cell A3=€�Y€�
if both cells A1 and A2 are FALSE then cell A3="Z"

Any help would be appreciated.