Formula IF value contains "number" or contains "text"

[Anonymous]

Hi Community,

I am working with a rule that i need a value back "yes" / "no" if the text contains inly text or only number. Example

TEST = IF('Table 1'[Value] <> "Only text","Yes","No")

EXAMPLE:

value	Result
AAAA	Yes
ABD	Yes
AKK1	No

TEST = IF('Table 1'[Value] <> "Only Numbers","Yes","No")

EXAMPLE:

value	Result
1324	Yes
2	Yes
112SD	No

thanks

[Anonymous]

Anyone else can help?

[Anonymous]

@v-stephen-msft thanks for the reply.

However, it should be the other way arround and also what about with the table for only text??

Regards

[v-stephen-msft]

Hi  @Anonymous ,

You may try this calculated column.

Result = ISERROR ( VALUE ('Table'[value] ))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.