Friday again, time for #formulafriday. You can download todays example here. Ok, so you are probably saying AUTOSUM, really?. Whats special about that then?. Yes we use it a lot- or I do whether is via Ribbon Home Tab Editing Group AutoSum OR use the KEYBOARD SHORTCUT ALT+= But....it also can do really really cool stuff, not just sum your columns of data. How about when you have a data set that looks like this?. Autosum will automatically sum … [Read more...]

## Formula Friday – Generate Random Odd Or Even Numbers With RANDBETWEEN

Happy Friday Excellers. Today let's look at RANDBETWEEN to generate some random numbers, but we can combine the function with others in Excel which is exactly what we are going to do today. This solution is in response to a question from a subscriber who wanted to be able to generate EVEN random numbers. He did not want any ODD numbers in his random data. But let's cover generating Random ODD numbers too, they are pretty much identical in process). (if you want to see my previous … [Read more...]

## Formula Friday – 3 Reasons To Use Named Ranges In Your Excel Formulas

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...]

- « Previous Page
- 1
- …
- 11
- 12
- 13
- 14
- 15
- …
- 17
- Next Page »