Numeric Column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
- Mark as New
- Subscribe to RSS Feed
- Permalink
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
Solved! Go to Solution.
- Mark as New
- Subscribe to RSS Feed
- Permalink
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 : )
