I'm sure its a simple formula but...

[twogoodtwo]

I think I am trying to creat an IF statement with 2 TRUE arguments but if anybody that could help, it would be greatly appreciated!

I would like the formaula to read:

If Cell A equals "1", return "Z" but if Cell A equals "2", return "Y", Finally if Cell A neither matches "1" or "2" return "False"

Rather than your usual IF statement, I would like to extend it - does that make sense?

Thanks in advance.

[swatsp0p]

This is called a "Nested IF" function:

assuming your data is Cell A7, in B7 enter this formula:

=IF(A7=1,"Z",IF(A7=2,"Y","False"))

HTH