FIXED Function
This function rounds a supplied number to a specified number of decimal places, and then converts this into text
Syntax: FIXED(number,[decimals],[no_commas])
Example:=FIXED(78554,2)
Result:78,554.00
Example:=FIXED(85485,0,0)
Result:85,485
This function rounds a supplied number to a specified number of decimal places, and then converts this into text
Syntax: FIXED(number,[decimals],[no_commas])
Example:=FIXED(78554,2)
Result:78,554.00
Example:=FIXED(85485,0,0)
Result:85,485
No comments:
Post a Comment