Two "IF" functions in one cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sunny - 01 Aug 2008 00:19 GMT

I was wondering if it is possible to insert two IF functions in one cell.

For instance =IF(A1="x","a","") and IF(A1="y", "b","")

Thanks.

Reply to this Message

Gary''s Student - 01 Aug 2008 00:25 GMT

=IF(A1="x","a",IF(A1="y","b",""))

Signature

Gary''s Student - gsnu200797

Reply to this Message

RagDyer - 01 Aug 2008 00:30 GMT

You do what is called "nesting".

=If(A1="x","a",If(A1="y","b",""))

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>I was wondering if it is possible to insert two IF functions in one cell.
>
> For instance =IF(A1="x","a","") and IF(A1="y", "b","")
>
> Thanks.

Reply to this Message