Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Can you re edit this formula for me =IFERROR(IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1))),MID("LHS",1,FIND("LHS",B4,1)))
Solved by S. L. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/07/2018 - 05:59
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern. :)
User 02/07/2018 - 06:00
Can you re edit this formula for me so that it works without IFERROR =IFERROR(IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1))),MID("LHS",1,FIND("LHS",B4,1)))
Excelchat Expert 02/07/2018 - 06:01
Sure thing! I should just remove the IFERROR then
Excelchat Expert 02/07/2018 - 06:01
Without the IFERROR, it will be like this:
Excelchat Expert 02/07/2018 - 06:01
User 02/07/2018 - 06:03
Excelchat Expert 02/07/2018 - 06:03
I took out the IFERROR function and had the previous formula as the result. Is the modified version working?
Excelchat Expert 02/07/2018 - 06:05
Please do ping me if there seems to be an error with the modified formula.
User 02/07/2018 - 06:08
Can you send me the modified version
Excelchat Expert 02/07/2018 - 06:08
Excelchat Expert 02/07/2018 - 06:08
This is the modified version without the IFERROR function.
User 02/07/2018 - 06:09
I need it to not include IF as well
Excelchat Expert 02/07/2018 - 06:09
If that will be the case, the formula will be divided into two.
Excelchat Expert 02/07/2018 - 06:10
The TRUE condition of the IF would be =LEFT(B4,3)
Excelchat Expert 02/07/2018 - 06:10
The FALSE condition would be =MID("RHS",1,FIND("RHS",B4,1))
User 02/07/2018 - 06:12
can you put them together
Excelchat Expert 02/07/2018 - 06:13
We would need the IF statement to put them together. I further modified the previous first formula. Please do check the one below if it works:
Excelchat Expert 02/07/2018 - 06:13
User 02/07/2018 - 06:14
User 02/07/2018 - 06:14
I have tried that but it doesnt work
User 02/07/2018 - 06:14
even with the IF statement
Excelchat Expert 02/07/2018 - 06:16
I see. WIll it be okay if you could share the file you're working on. I would like to see how the cells are referenced so I could diagnose the formula more. Thanks!
Excelchat Expert 02/07/2018 - 06:17
Just to clarify, is an error being produced if you enter the IF statement in your file?
User 02/07/2018 - 06:17
User 02/07/2018 - 06:18
what is your email address
Excelchat Expert 02/07/2018 - 06:18
I see. It seems the IFERROR then is essential. Oh, unfortunately we aren't allowed to share personal info within this platform. You maybe able to upload the file via the clipboard icon to the right of this chatbox.
User 02/07/2018 - 06:19
no that doesnt work
Excelchat Expert 02/07/2018 - 06:20
Or you could as well upload your file via google sheets and share the link in here. This would allow me to access the file.
User 02/07/2018 - 06:20
User 02/07/2018 - 06:20
quick please
Excelchat Expert 02/07/2018 - 06:20
I've sent an access request for the file. Please do accept. Thanks!
Excelchat Expert 02/07/2018 - 06:23
I see. It seems you need assistance in answering column I, which extracts the LHS and RHS of the column B description. Is this correct?
User 02/07/2018 - 06:23
User 02/07/2018 - 06:23
Excelchat Expert 02/07/2018 - 06:23
Sure thing, let me work on it the soonest.
Excelchat Expert 02/07/2018 - 06:26
Already done! Please see formulas under column I for your review. Should you have any queries, please feel free to ask.
Excelchat Expert 02/07/2018 - 06:32
Just to provide a simple explanation on how the formula works, you'll notice the ISERROR(FIND("LHS",B9)). This just means that the first attempt would be to find "LHS" in cell B9. If it can't be found there, the FIND function will return an ERROR. If this happens, then ISERROR(error) would be TRUE. If indeed this is TRUE, then meaning the answer would be "RHS" (since FIND("LHS" didn't come true). However, if the FIND("LHS",B9) indeed finds a value, then it will automatically return "LHS"
Excelchat Expert 02/07/2018 - 06:36
Hello! Were you able to confirm the solution provided? Thanks!
Excelchat Expert 02/07/2018 - 06:37
If there is no more concerns, You can now end the session via the button on your upper right (sorry, can't do it from our end). I would also appreciate it if you can leave a great rating after this.Thanks so much for using Got it pro and have a nice day! :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc