IF THEN ELSEIF ELSE error

ppatane

I am getting an error in the following formula:

IF Left([Firm Administrative Code 987654], 1) = 0 Then 'F00' ELSEIF

Left([Firm Administrative Code 987654], 1) = 4 Then 'F01' ELSEIF

Left([Firm Administrative Code 987654], 1) = 5 Then 'F05' ELSEIF

Left([Firm Administrative Code 987654], 1) = 8 Then 'F08'

ELSE 'F0 -ERROR'

ENDIF

The error occurs at the = sign before 8 in the 3rd to the last row

I have even tried copying the Left function from the previous row and pasting it over what I have and changing the condition, but it actually gives an error immediately.

UPDATED: NM, it's vstring and needs quotes around the numbers after the = signs

Workflow

Accepted answers

flying008

Hi, @ppatane

A clear formula for you :

Switch(ToNumber(Left(ToString([Firm Administrative Code 987654]), 1)),'F0 -ERROR',0,'F00',4,'F01',5,'F05',8,'F08')

All comments

Qiu

@ppatane
Good to know it is now working.
The string generated from Left function has to be compared with a string, in your case, '5' 😁

flying008

Hi, @ppatane

A clear formula for you :

Switch(ToNumber(Left(ToString([Firm Administrative Code 987654]), 1)),'F0 -ERROR',0,'F00',4,'F01',5,'F05',8,'F08')

ppatane

Wow, flying008! I didn't know the Switch function. I like it!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167