FIXED

FIXED(number [,decimals] [,no_commas])

Returns the text string of a number rounded to a fixed number of decimal places.

numberThe number you want to round and convert to text.
decimals(Optional) The number of digits to the right of the decimal point.
no_commas(Optional) A logical value indicating the type of comma format to use:
False (or 0) = no commas (default)
True (<> 0) = commas will separate thousands, millions

REMARKS
* This function returns numbers as text.
* You can tell that this function returns a text string because the result is left-aligned. Numerical values are right-aligned by default.
* The "number" can be a number, a reference to a cell containing a number or a formula that evaluates to a number.
* If "decimals" < 0, then "number" is rounded to the left of the decimal point.
* If "decimals" is left blank, then 2 is used.
* If "decimal" is empty, then
* Any numbers formatted with this function can still be used in numerical formulas because numbers entered as text are automatically converted to numbers when performing calculations.
* Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be as large as 127.
* You can use the DOLLAR function to return a text string of a number with the dollar formatting $0,000.00.
* You can use the TEXT function to return a text string of a number in any format.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 AB
1=FIXED(1234.567, 1) = 1234.6=A2 = 1230
2=FIXED(1234.567, -1) = 1230=2*A2 = 2460
3=FIXED(-1234.567, -1) = -1230=2*1230 = 2460
4=FIXED(12000.75, 1, TRUE) = 12001 
5=FIXED(12000.75, 1, FALSE) = 12000.8 
6=FIXED(44.332, 2) = 44.33 
7=FIXED(44.332, ) = 44.33 
8=FIXED(44.332) = 44.33 
9=FIXED("some text") = #VALUE! 


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top