Test if a string variable with "-" is numerical

[rohith.prabhu]

Hello @Anonymous2,

Check this ,

How to ensure inputs are numeric values and positive numbers only?

Hey @moreirasa1 Just keeping it simple, you will want to check if it’s Numeric before checking if it’s less than 0 The condition can be like this: If(IsNumeric(sNumberOne) And IsNumeric(sNumberTwo), CInt(sNumberOne)<0 And CInt(sNumberTwo)<0, True) So if you place that entire line into your condition, it will first check if both values are numeric, then check if they are <0. If they are not numeric it will go to the True side. Basically, I used an inline If statement, useful for making compar…