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