Skip to main content
Home
Live to Learn!

Main navigation

  • Home
  • Learn
    • FoxPro
    • MS-DOS
    • C PRG
    • Java
    • ASP
    • Ruby on Rails
    • ASP.NET
    • E-Books
    • Exam Preparation
    • Tools
  • Blog
  • Forums
  • Contact
User account menu
  • Log in

Breadcrumb

  1. Home
  2. FoxPro Programming

Numeric Functions in FoxPro

Book navigation

  • FoxPro Commands - Part 1
  • Foxpro commands - Part 2
  • Data Types in FoxPro
  • Numeric Functions in FoxPro
  • Creating a Program
  • Input and Output Statements in Foxpro
  • Control Structures in Foxpro
  • Creating menu in Foxpro for DOS
  • Simple Journal Entry program
  • Simple Ledger creation & Posting Program
  • Trial Balance Program
  • Balance Sheet Program
  • Simple Weekly Calendar Generation
  • How to install FoxPro 2.6 in Windows 10 / Windows 8 / Windows 7?
  • How to install FoxPro 2.6 on Linux OS (Ubuntu 20.04 | 20.10 | 21.04)?
  • How to install FoxPro in Windows 10 64 bit using VDosPlus?
By Karthikeyan , 12 May, 2014

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

  • Add new comment
Tags
Foxpro

Comments

Featured Blog Posts

Convert Currency in Number to Words (Indian Rupees) - MS Excel
Foxpro Tutorial and Programs
Convert Currency in Number to Words in MS Word
Convert Currency in Number to Words (Indian Rupees) - Version 2
Best way to Use Rupee Symbol in Windows – Easy steps
Convert Currency in Number to Words - MS Access
Creating All in One Windows XP DVD with all Important Applications
RSS feed

© 2009-2025 Live to Learn.In

Terms of Use | Privacy Policy