Microsoft Office Tutorials and References
In Depth Information
EXACT
For example:
=DOLLAR(“15000”) results in $15,000.00.
=DOLLAR(“15000.23”) results in $15,000.23.
If you input a negative number, the DOLLAR function will convert the negative number as follows:
=DOLLAR(“-15000”) results in ($15,000.00). You can also use the DOLLAR function with a cell
reference. For example, if you have a list of numbers you want to convert to currency format, you
could apply the formula =DOLLAR(C5) , where C5 equals 25, the result would be $25.00. Keep in
mind, however, using this function overrides the use of the format cells command.
This can be a number or cell reference or even a number that
evaluates to a number.
NUMBER
The decimal is the number of digits or decimal places to the right of
the decimal. If they are omitted, Excel assumes two places.
DECIMALS
EXACT
EXACT compares two text strings and returns TRUE if they’re exactly the same, and FALSE
other wise.
=EXACT(text1,text2)
The EXACT function compares two text strings to see if they are the same. The EXACT function
can operate from text within the function or via cell referencing.
The text is the first text string and then the second text string.
TEXT 1, TEXT 2,...
For example:
=EXACT(“BILL”,”bill”) results in FALSE.
=EXACT(“BILL”,”BILL”) results in TRUE.
As you see in Figure 12.3, there are two examples comparing ranges of cells with the EXACT
function. The first, displays TRUE when an asset is complete using cell referencing. The second
compares a single cell reference to a range in the form of an array. If you had a list of assets,
and all assets had unique identities, you might want to see if the asset is in the list. For this, you
would use the formula as shown in Figure 12.3:
{=Or(Exact(Cell Reference, Compare Range))}
Search JabSto ::




Custom Search