Nested IF statements with Text as IF and THEN (Excel 2007)
I am trying to translate the text values in one column to be a new value in another column. I keep receiving a #Name? error when I try the following in the destination field:
=IF(A2=”Smith”),"Team 1",IF(A2=”Jones”),“Team 2”
Will Excel 2007 allow text values to be entered as both an IF and THEN ?
Is there a different way to do this formula?
Thank you!
Try:
=IF(A2=”Smith”,"Team 1",IF(A2=”Jones”,“Team 2”,""))
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
mrsbigglesworth,
Your other post has been closed after I responded to it.
Try:
=IF(A2="Smith","Team 1",IF(A2="Jones","Team 2",""))
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks