Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Numeric functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - IntegerPart function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Numeric - IntegerPart

Syntax:
=IntegerPart(Number)

Description:
Returns the first integer value below than the Number specified.
Equivalent to the Visual Basic Int function.

Example:
Return the first integer below 1.23 (=1)
=IntegerPart(1.23)
Return the first integer below -1.23 (=-2)
=IntegerPart(-1.23)

litLIB