by Nico Mellett | Apr 18, 2023 | Excel Functions, Uncategorized
In a Nutshell SIGN is a Microsoft Excel function that tells us the sign of a number (i.e. whether the number is positive, negative, or zero). It does this by returning either a 1 (for a positive number), 0 (for zero) or -1 (for a negative number). It is categorised in...
by Nico Mellett | Feb 7, 2022 | Excel Functions, post
In a Nutshell To CONCATENATE is to “Join” or “Combine” data together. Assume you have numerous columns of data to combine, and manually combining the data isn’t a possibility. You can use the CONCATENATE function to combine content from...
by Nico Mellett | Feb 6, 2022 | Excel Functions
How To Use the IF Function in Excel In a Nutshell The IF function is an extremely versatile logical function in Excel. It is used to perform a logical test to see if a certain condition is true or false. For example, “Is the value in cell C5 greater than...
by Nico Mellett | Jul 15, 2021 | Excel Functions
In a Nutshell TRIM is a Microsoft Excel function that removes all spaces from a string of text, except for single spaces between words. The TRIM function is useful for cleaning up text imported into Excel that may have irregular spacing. It is categorised in the Text...
by Nico Mellett | Jul 13, 2021 | Excel Functions
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...
by Nico Mellett | Jul 12, 2021 | Excel Functions
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...