define precision & compare

[Kousy]

Hi all,

I have to compare a value say 5.5002, is within limits of 4.25 & 5.50. I am using range & coerce function (including upper & lower limit) to do that. This 5.5002, I got by interpolation. After formatting 2 digits of precision, I am comparing this 5.5002 as 5.50, but is not bound within limits. How can I do truncation of this single precision no. to 2 digits of precision & declare it well within limits?

Thanks for your help.

Regards,

Kousy

[devchander]

I used to do a pretty lengthy prodedure to do this.

First I would convert the numeric value to a fractional string ( using convert to fractional and exponential string  function) with  precision set as 2

And then, convert it back to numeric ( using convert fractiona exponential string to number function) an get a floating integer value truncated to 2 digit precision.

Not a elegant method, but it worked for me

[Kevin_Price]

Similar idea if you're sure your numbers won't overflow:  multiply by 1000, round to int, compare with a range that is similarly scaled by 1000 & rounded.

-Kevin P.

[Kousy]

Thanks Devchander. It worked fine. Its a roundabout way, still fine. Thansk once again.

Kousy

[devchander]

Glad to have been of assistance