We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel Code Error
Cotta
Posts: 3,667 Forumite
in Techie Stuff
Hi All,
I'm trying to use the following code to return values based on what is in cells F3 and C3, however the following code is not being accepted - does anyone know where I've went wrong?
=IFERROR(IF(F3="Man City",IF(LEFT(C3,2)="PL","Champion",IF(LEFT(C3,1)="W","Liverpool",IF(LEFT(C3,1)="S","Liverpool",IF(LEFT(C3,1)="G","Liverpool")))),IF(G3="ManchesterUtd",IF(LEFT(C3,1)="M","Manchester",IF(LEFT(C3,1)="H","ManchesterCity")),F3)),F3)
Thanks
I'm trying to use the following code to return values based on what is in cells F3 and C3, however the following code is not being accepted - does anyone know where I've went wrong?
=IFERROR(IF(F3="Man City",IF(LEFT(C3,2)="PL","Champion",IF(LEFT(C3,1)="W","Liverpool",IF(LEFT(C3,1)="S","Liverpool",IF(LEFT(C3,1)="G","Liverpool")))),IF(G3="ManchesterUtd",IF(LEFT(C3,1)="M","Manchester",IF(LEFT(C3,1)="H","ManchesterCity")),F3)),F3)
Thanks
0
Comments
-
It seems to work for me. The only issue I can see if there's a space in the LEFT just after the second "Liverpool" which might cause a few problems.:wall: Flagellation, necrophilia and bestiality - Am I flogging a dead horse? :wall:
Any posts are my opinion and only that. Please read at your own risk.0 -
Thanks, the space was the problem.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.1K Banking & Borrowing
- 253.5K Reduce Debt & Boost Income
- 454.2K Spending & Discounts
- 245.1K Work, Benefits & Business
- 600.7K Mortgages, Homes & Bills
- 177.5K Life & Family
- 258.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.6K Read-Only Boards