formula not picking up chars 1

[ABetha]

if val({vSerialNperation})< 0 then
formula = 1
else
formula = 0
end if

My formula is not picking up special characters like '?' '!' etc its counting them as 0 when these are not valid and I am looking for it to return a 1 for these characters as well as numbers less than 0.

 

[IanWaterman]

Try

if not(isnumeric({vSerialNperation})) or val({vSerialNperation})<= 0 then
formula = 0
else
formula = 1
end if

Ian

 

[ABetha]

Thank You Ian this worked