Numeric Column

[AS]

Hi Everyone,

I have 2-3 column in excel that containing both numeric and string data and it's data type is string. But I need to apply some numeric formula's on it. so I tried to parse that column in To Number() function. but getting wrong result please help me. Example below

A	B	C	D	Result
NA	NA	x	NA	review
NA	NA	x	NA	review
221	0	x	NA	Result B within 90
1095	244	x	NA	review
NA	NA	NA	NA	No C
1095	244	x	x	scope

Note- "To Number function has space in formula because it is showing error to type else these both are together"

IF To Number([A])<91 THEN "Result A <90"

ELSEIF To Number([B])<91 THEN "Result B within 90"

ELSEIF [C]!="x" THEN "No C"

ELSEIF [D]="NA" THEN "review" ELSE "scope" ENDIF

Thanks in advance

[atcodedog05 · Accepted solution]

Hi @AS 

Here is how you can do it. I am checking is A or B a number and the converting it to compare.

Formula:

IF REGEX_Match([A], "\d+") and ToNumber([A])<91 
THEN "Result A <90"
ELSEIF REGEX_Match([B], "\d+") and ToNumber([B])<91 
THEN "Result B within 90"
ELSEIF [C]!="x" THEN "No C"
ELSEIF [D]="NA" THEN "review" 
ELSE "scope" ENDIF

Workflow:

Hope this helps : )