IF AND OR BUT NOT SURE

[tracktor]

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.

 

[Bob Phillips]

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

--
---
HTH

Bob


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

 

[Ian Grega]

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