IF AND OR BUT NOT SURE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tracktor - 20 May 2008 09:16 GMT

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.

Reply to this Message

Bob Phillips - 20 May 2008 09:34 GMT

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

Signature

---
HTH

Bob

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

> 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.

Reply to this Message

Ian Grega - 20 May 2008 09:46 GMT

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

> 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.

Reply to this Message