If sum = between 95 and 105

[ibiubu]

I have a field that contains the following:

80 12 6

I want to do a calc that returns "Yes" if the field adds up to between 95 and 105

Is this possible?

Larry

[Lee Smith]

Hi Larry,

Is your pattern 80 12 6 going to be constant (i.e. 2 digits, and a space 2 digits, and a space 1 digits). or can it change or appear such as 80126, or 9 101 13, or 100 1 12 etc.?

Lee

[-Queue-]

Let( S = Evaluate(Substitute( Trim(field), " ", "+" ));

Case( S >= 95 and S <= 105; "Yes" ) )

This will work for all numbers separated by a space. field should be a text field also.