Excel Function : FIXED
Category
Text
Description
Formats a number as text with a fixed number of decimals
Microsoft Excel Reference Page
https://support.office.com/en-us/article/FIXED-function-ffd5723c-324c-45e9-8b96-e41be2a8274a
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.
