IsEqual([Value],[Value],[Value]

This function is used to test equality of floating point numbers, if the numbers are equal this function returns true. The first two values are used for the test. For the two numbers to be considered equal, the difference between them must be less than the third value.

Examples:

Output 'numbers are equal' if IsEqual(1.25,1.245,0.01);

Related functions:

log , cos , exp , abs , int , sqrt , sin , atan2 , ceil , floor , log10 , IsNull , NVL , MinValue , MaxValue , Min , Max , Sum , Cum , Round , RoundToQuarter , RoundToTickSize