Can anyone see where this formula is going wrong? It won't accept it. I tried changing the parenthesis but still wont accept. Appreciate your help on this.
IF(D2="ATLAS",CONCATENATE(G2,LEFT(E2,6),
IF(D2="DOGS",CONCATENATE((G2,LEFT(E2,6)),
IF(D2="GCS",CONCATENATE(G2,LEFT(E2)),
IF(D2="IOWA",CONCATENATE((G2,MID(H2,7,4),RIGHT(H2,1)),
IF(D2="RADAR",CONCATENATE(G2,CE,AC))))))
Hi NYC4Life,
You can do this yourself if you use the EVALUATE tool in Excel. See http://www.officearticles.com/excel/...soft_excel.htm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There should be 2 parentheses on the first line after the 6. Other than that, Marvin's idea is a great one.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Some "questions" highlighted in red:
IF(D2="ATLAS",CONCATENATE(G2,LEFT(E2,6)),
IF(D2="DOGS",CONCATENATE((G2,LEFT(E2,6)),
IF(D2="GCS",CONCATENATE(G2,LEFT(E2,6)),
IF(D2="IOWA",CONCATENATE((G2,MID(H2,7,4),RIGHT(H2,1)),
IF(D2="RADAR",CONCATENATE(G2,CE2,AC2))))))
Last edited by TMS; 06-03-2013 at 10:59 AM. Reason: Mark additional errors => opening brackets
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Oh, and there's no FALSE condition if none of those are TRUE.
Regards, TMS
Try this:
=IF(D2="ATLAS",CONCATENATE(G2,LEFT(E2,6)),
IF(D2="DOGS",CONCATENATE(G2,LEFT(E2,6)),
IF(D2="GCS",CONCATENATE(G2,LEFT(E2,6)),
IF(D2="IOWA",CONCATENATE(G2,MID(H2,7,4),RIGHT(H2,1)),
IF(D2="RADAR",CONCATENATE(G2,CE2,AC2), "no conditions match")))))
You also had some doubled up opening brackets.
@Guys: I don't think you can use Evaluate if you can't get Excel to accept the formula.
Regards, TMS
And, a bit shorter:
=IF(OR(D2="ATLAS",D2="DOGS",D2="GCS"),CONCATENATE(G2,LEFT(E2,6)),
IF(D2="IOWA",CONCATENATE(G2,MID(H2,7,4),RIGHT(H2,1)),
IF(D2="RADAR",CONCATENATE(G2,CE2,AC2), "no conditions match")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks