Archive for the ‘Functions’ Category

Removing #N/A error in Excel using ISNA()

Posted on February 17th, 2009 by Joseph Harris

The #N/A error happens most often when a lookup function cannot find a result. You can manually remove the all of your #N/As or you can stop them in your original formula. A simple and effective way of trapping the #N/A errors and replacing them with whatever you would like is to use the ISNA() [...]

Percentile – Finding the Percentrank() in Excel

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…

Excel CELL () Function

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, [...]

Excel Concatenate Function

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 [...]

Excel Function “AND”

Posted on November 16th, 2008 by Joseph Harris

AND function use

ABS Function, Absolute Value in Excel

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 [...]