by Nico Mellett | May 10, 2023 | Excel Functions, post
In a Nutshell The IFERROR function is a powerful tool that can be used to trap and handle errors in Excel formulas. It can be used to replace error values with text, numbers, or other formulas. Syntax The syntax for the IFERROR function is as follows: =IFERROR(value,...
by Nico Mellett | May 2, 2023 | Article, post
Financial modelling is an essential tool for businesses, investors and financial analysts. It is a process of creating a mathematical representation of a financial situation or system using various financial concepts and data. The aim is to create a model that can be...
by Nico Mellett | May 1, 2023 | Excel Functions, post
In a Nutshell The TEXTJOIN function combines the text from multiple ranges and/or strings in one cell. It provides the option to add delimiting characters (ike dashes or spaces) between all the different strings being joined together. Syntax =TEXTJOIN(delimiter,...
by Nico Mellett | Apr 28, 2023 | Excel Functions, post
In a Nutshell The MIN function is used to find the lowest value in a range of values. Syntax =MIN(number1, [number2], …) The arguments (number1 , number2, …) are up to 255 numbers for which you want to find the minimum value. The first one is required; the rest are...
by Nico Mellett | Apr 22, 2023 | Excel Functions, post
In a Nutshell The CONCAT function combines the text from multiple ranges and/or strings. Syntax =CONCAT(text1, [text2], …) The arguments (text1, text2, …) are up to 253 items to be joined. Each argument listed in the brackets can either be a string, or an array of...