Excel Functions
Excel VLOOKUP Function
In a Nutshell VLOOKUP is a Microsoft Excel function that returns a value in a specified column of a range, based on a specified lookup value What does that mean? It searches for the specified value in column 1 of your table, and returns a matching value from another...
Excel PI Function
In a Nutshell The Excel PI function returns the value of pi (the mathematical constant), accurate to 14 decimal places (3.14159265358979). The Excel PI function is categorised in the Math & Trig Function Library on the Formulas tab: Syntax PI() The PI function has...
Excel CHAR Function
In a Nutshell The Excel CHAR Function returns the character represented by a specified code number from the character set of your computer. In other words, the purpose of the function is to display a character based on a supplied number. E.g. code 128 represents €....
Video: 7 Essential Excel Functions
Character code list for Excel CHAR function (on a PC)
The CHAR function returns a character specified by the code number from the character set for your computer. For example, CHAR(34) returns a double quotation mark (") and CHAR(10) returns a line break. The full list can be accessed easily from within Excel by clicking...