Microsoft Office Tutorials and References
In Depth Information
FIXED
What if you had a cell that contained the names of people and the city and state they lived in.
You could combine the FIND function with the MID function to extract a text string. Take a
look at Figure 12.4. The formula =Mid(C6,1,Find(“ “,C6,1)-1) results in the extraction of
the first word, which in this case is a name in the cell, regardless of the length of the first
name. See entries in this chapter for LEN and MID for additional details.
Figure 12.4
The FIND function
combined with the MID
function can extract
text strings in cells
regardless of the
string length.
A
First name extraction
FIXED
The FIXED function rounds a number to a specified number of decimals, formats the number
in decimal format using a period and commas, and returns the result as text.
=FIXED(number,decimals,no_commas)
The FIXED function can round numbers in a cell. You can use the FIXED function with text in
the function or with cell referencing. Use the FIXED function to round numbers to decimals,
hundreds, and thousands. You should notice that the examples in Figure 12.5 round a
number to decimals, tens, hundreds, and thousands using the FIXED function.
The number refers to the number you want to round or convert to text.
NUMBER
The decimals refer to the number of decimal places to the right.
DECIMALS
The no commas is a logical result in that if True, it prevents the
function from including any commas in the text returned result.
NO COMMAS
Search JabSto ::




Custom Search