Excel Function : FIXED

Download now!

Excel Function : FIXED




Formats a number as text with a fixed number of decimals

Microsoft Excel Reference Page


Syntax and Description of the FIXED Excel Function

to calculate distance using latitude and longitude I'm trying to get the syntax right for the following excel function: =ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Lon2-Lon1)))/PI() *6371 In the above formula the Lat1, Lon1, Lat2, and L

About FIXED Excel Function

The FIXED function rounds a number to a specified number of decimal places, and returns the result as text with a fixed number of decimal places. FIXED(number,decimals,no_commas) number - The number to round. decimals - The number of decimal places to use. no_commas - Optional. Specifies whether to use commas in the result. If omitted, commas are used.