# Numeric Functions in FoxPro

 Function Description Example & Output Abs() Returns absolute value of the specified numeric expression abs(-17) 17 Int() Returns integer value int(17.15) 17 Floor() Returns nearest integer value that is less than or equal to the given number Floor(17.85) 17 Ceil() Returns nearest integer value that is higher than or equal to the given number Floor(17.85) 18 Mod() Returns remainder value Mod(45,6) 3 Round() Returns a numeric value rounded to a specified number of decimal Round(17.85) => 18 Round(17.15) => 17 Min() Returns lowest value from the list of values given (based on ASCII value – applicable to numbers, characters, date expressions) Min(10,17,18,5) => 5 Max() Returns highest value from the list of values given (based on ASCII value – applicable to numbers, characters, date expressions) Min(10,17,18,5) => 18 Sqrt() Returns square root of the given expression Sqrt(144) => 12 Log() Returns logarithmic value of the given expression. Log(10) => 2.30259 Log10() Returns logarithmic base 10 value of the given expression. Log10(10) => 1.0000 Acos() Returns cosine value of the given expression Similarly, asin(), atan() can also be used. Acos(0.5) = > 1.0472
Tags:

Recommended :

 FoxPro Programming Quick Reference e-Book (New! Revised Edition)