LinkBack URL
About LinkBacks
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
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
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks