Posted on January 6th, 2009 by Joseph Harris
Finding and displaying the percentile of specific results can be valuable to your audience. Sometimes stand alone numbers do not tell the story, but, if I know that 80% of the other results are lower than me, that tells a more complete story…
Posted on November 20th, 2008 by Joseph Harris
The CELL function can be used to find out information about a cell such as formatting, size and contents.
Format:
cell(info type, range)
“info type” is the type of information you would like to retrieve from the cell. “info type” can be any of the following values:
“address” Reference of the first cell in reference, as text.
“col” Column number [...]
Posted on November 20th, 2008 by Joseph Harris
The Excel concatenate function can be used to combine multiple cells into one.
Syntax
CONCATENATE (text1,text2,…)
Text1, text2, are items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references. Real world example:
Cell A1 contains: I
Cell A2 contains: Love
Cell A3 contains: Concatenate
Type =concatenate(a1,a2,a3) in A4
The result in A4 would [...]
Posted on November 16th, 2008 by Joseph Harris
AND function use
Posted on November 12th, 2008 by Joseph Harris
ABS can be used to display the absolute value of a number. The absolute value of a number is the number without its sign.
The format for ABS is:
=ABS(number)
“number” can be a cell reference, a function or a formula that returns a number of which you want the absolute value.
Example:
Cell A1 contains -5
=ABS(A1) Result is [...]
Posted on October 23rd, 2008 by Joseph Harris
Vlookup
