Please enable JavaScript to view this site.

From version 6.2.57 - This program will allow you to compare two numeric values and return whether Parameter 1 is Greater Than, Equal To or Less Than Parameter 2. The values passed in may contain non numeric characters such as a currency symbol, thousand delimiter etc. and may also be negative (with the minus sign at the right of the number e.g. £1.00-). They may also contain different numbers of decimals.

Parameter

In

Len

Out

Len

Comment

PARM1

Value to compare against

21

*GT

*EQ

*LT

3

PARM1 > PARM2

PARM1 = PARM2

PARM1 < PARM2

PARM2

Value to compare with

21


 


PARM3

Decimal point e.g. “.” or ”,”

1


 

If left blank defaults to “.” This is required for Europe where decimal point is a comma.

PARM4


 


 


PARM5


 


 


PARM6


 


 


Examples

PARM1

PARM2

PARM3

Returned

£1,234.567

1234.567

 

*EQ

1.24-

1.24

 

*LT

1.245

1.24

 

*GT

1.234,567

1.234,568

,

*LT