Contains function

M Scrog

I am having trouble with a formula that contains multiple "If(contains)" function. The following returns unparsable.

=IF(CONTAINS("52", [Account #]@row), "52", IF(CONTAINS("53", [Account #]@row), "53", IF(CONTAINS(“54”, [Account #]@row)”54”, "")))

Amber Eakin

Could you share a screenshot of the sheet?

Amber Eakin

This is so strange. How about this? It looks the same to me, but my sheet is accepting it.

=IF(CONTAINS("52", [Account #]@row), "52", IF(CONTAINS("53", [Account #]@row), "53", IF(CONTAINS("54", [Account #]@row), "54")))

Amber Eakin

Hello, @M Scrog - It looks like a syntax error. Does this work?

=IF(CONTAINS("52", [Account #]@row), "52", IF(CONTAINS("53", [Account #]@row), "53", IF(CONTAINS(“54”, [Account #]@row), "54")))

M Scrog

Thank you @Amber Eakin - I am still receiving an "unparseable" error.

Amber Eakin

Could you share a screenshot of the sheet?

M Scrog

Amber Eakin

This is so strange. How about this? It looks the same to me, but my sheet is accepting it.

=IF(CONTAINS("52", [Account #]@row), "52", IF(CONTAINS("53", [Account #]@row), "53", IF(CONTAINS("54", [Account #]@row), "54")))

M Scrog

@Amber Eakin Thank you! That did it. I think there were some spacing issues based on my comparison.

Lucas Rayala

Hi @M Scrog, if you just want the first two digits, you could do this instead:

=LEFT([Account #]@row, 2)

If you want the Series to be a number (right now your computer thinks it's a word) wrap my function in a value function like this:

=VALUE(LEFT[Account #]@row, 2))