VBA Fix Function: The Fix function in VBA truncates the given number to an integer and returns the rounded off integer number. This function both positive and negative numbers to zero.

Syntax

Parameter

Number (required) – This parameter represents the number that you want the integer part of.

Return

This function returns an integer value after truncating the specified number.

Example 1

Output

-17

Excel VBA Fix Function

Example 2

Output

17

Excel VBA Fix Function

Example 3

Output

VBA Fix Function

Pin It on Pinterest

Share This