Nested IF formulas are extremely useful for complex decision making on a spreadsheet, but they can also be long, messy and convoluted.
This blog post explores 4 alternatives which are easier, faster and cleaner than the classic nested IF.
Excel CHAR Function with Examples
The CHAR function in Excel returns a character specified by a code, from the character set of your computer.
In this blog post, we look at why you might want to use the CHAR function, and some examples of it in action in Excel.
The CHAR function is typically used to insert, or to find, a character which you ordinarily cannot type from your keyboard.
To use it you will need to find out what the code is for the character you want to use.
You can search online for a full list of these character sets so that you know each code (or at least the one you need at the given time). These character sets differ between the Windows and Mac computers, and are also dependent upon the language used.
[Read more…] about Excel CHAR Function with Examples5 Reasons Why your Excel Formula is Not Calculating
When your Excel formula is not calculating, or not updating, it can be very frustrating. Your formulas are the driving force for your spreadsheet.
There are 5 reasons for your Excel formula not calculating. In this tutorial we explain these 5 scenarios.
Watch the Video – Excel Formula Not Calculating
4 Ways to Group Time in Excel – PivotTables and Formulas
If your spreadsheet contains a list of times, it is useful to group time in Excel into intervals such as 30 minutes, hourly or every 6 hours.
Fortunately, Excel provides a variety of methods to group time depending on what you need. In this blog post, we look at 4 ways to group time in Excel using PivotTables and formulas.
[Read more…] about 4 Ways to Group Time in Excel – PivotTables and FormulasExcel MOD Function – 4 Examples
The Excel MOD function is used to return the remainder after one number is divided by another. Simple, but there are some very useful examples of the MOD function.
In this blog post, we explore 4 Excel MOD function examples. Hopefully this will help to see how versatile this function can be.
To start we better have a quick introduction to how to use the MOD function. It looks like this;
=MOD(number, divisor)
You need to provide it first with the number you want to divide, and then the number you want to divide it by (divisor).
You can see some basic examples of this below.
Ok, lets get on with some more impressive real-world Excel MOD function examples.
[Read more…] about Excel MOD Function – 4 Examples
