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!
mrsbigglesworth,
Try:
=IF(A2="Smith","Team 1",IF(A2="Jones","Team 2",""))
Have a great day,
Stan
stanleydgromjr
Windows Vista Business, Excel 2003 and 2007
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.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks