Hey Excellers thanks for joining me for another #formulafriday. Today I want to share my top 3 reasons to used named ranges in your formulas. Firstly......What Is A Named Range? A named range is simply a name that refers to either a cell, a range of cells, a constant value or a formula. These names can then be used in a formula to replace a constant value or a cell reference. For example, if you have a constant value in a cell such as Exchange Rate, you can name that cell … [Read more...]

## Formula Friday – Using The AND Function To Highlight Cells Meeting Multiple Logical Conditions

HAPPY FRIDAY EXCELLERS. More Formula Fun time.... Today let's look at a small but mighty powerful formula. AND. We can use it to test multiple conditions ( up to 255 logical ones!). The Syntax of the formuls is =AND (logical1, [logical2], ...) Where logical1 - is The first condition or logical value to evaluate logical2 - is [optional] The second condition or logical value to evaluate So let's use it with conditional formatting to highlight a whole row in a data … [Read more...]

## Formula Friday – Easily Calculate The Number Of Days Between Dates with the DAYS() Function

Hello Excellers, Formula Friday here again, today let's look at one of the new functions that was introduced with the release of Excel 2013. So it is a short and snappy #formulafriday today, there are only two arguments to this Function =DAYS(end_date,start_date) So it is fairly simple, Excel will calculate the number of days between two dates. Let's take a look at an example using some sporting dates. I am a tennis fan, so let's see how many days I have to wait until the … [Read more...]

## Formula Friday – Excel Rank Function – Who is The Leader Of The Pack?

HAPPY FRIDAY EXCELLERS.... let's look at Ranking today. The RANK function will compare numbers to other numbers contained in an Excel list. So if you apply RANK to a list of numbers, Excel will apply a ranking number to them either in an ascending order or a descending order. There a a few parts or arguments to the function. =Rank( number, array, [order] ) number - this is the number to find the rank for array - this is the range or array of number to use for ranking order- … [Read more...]

## Formula Friday – Need To Test Your Formulas? It’s Easy Just Hit F9!

Hello Excellers, time for some more formula fun. But this time let's look at checking our formulas to ensure they are working as expected. If you work on a large spreadsheet solution, it is really handy to be able to break down formulas into bite size chunks especially if they are some what complex, to pinpoint any errors that you may have. We can do this using the F9 key. As always let's use an example to work through. It shows an extract of transactions from January to … [Read more...]

- « Previous Page
- 1
- …
- 15
- 16
- 17
- 18
- 19
- …
- 21
- Next Page »