Happy Friday Excellers...I found this little Function out by accident, looking to see what decade a date was from, and thought it may have it's uses along the way in Excel. Whilst most numbers will let you round up or down to a specific decimal place, the FLOOR function will allow you to specify yourself what number you want to round down to. Basically this function will round a number down to zero, to the nearest multiple of significance which you specify. FLOOR Function … [Read more...]

## Formula Friday – Setting Excel To Calculate Formulas Manually

Happy #formulafriday Excellers. If you are working on large Excel spreadsheets, they may take some time to update and calculate especially if you have a slow pc or laptop. A great easy way to avoid this happening is to cut short the updating time by switching the Excel formulas to calculate manually or on demand not automatically. By default Excel will automatically calculate any formula that you type in or insert into it. That's what you want it to do right?. Most times yes, but its … [Read more...]

## Formula Friday – Quickly Switch From Cell Values To View Formulas – An Excel Shortcut

Happy Friday Excellers. Welcome to #formulafriday. Something a little different today with a great Excel shortcut. This is a great trick to enable you to toggle between your formulas and cells values. It's super easy all you need to do is hit CTRL+' (The 'Grave accent key is is below the escape key on the far upper left of a standard keyboard). If you want to use the MENUS on Excel then it's the following Home Key Formulas Tab Show Formulas Tab You can see in my … [Read more...]

## Formula Friday – SUM Only NEGATIVE Numbers In An Excel Range Using The SUMIF Function.

by Barbara —4 Comments

Happy Friday Excellers. It's #formulafriday time. Today let's look at counting all of the negative values in a data range. This formula is based on the SUMIF Function. I have to say it is one of THE most useful functions I find in Excel, used to calculate conditional sums, and in the example we will look at today, we will count all of the negative values in a data range. I have set up an example to look at the number of refunds that Sales Representatives have had to give in a period … [Read more...]

## Formula Friday – Count How Many Numbers In A List Are Greater Than The Average Using The COUNTIF Function.

Want Some Formula Fun? Course we do it is #formulafriday time. Here is a great one, I use it quite often. How to find how many numbers in your list are greater than the average. Think about it you..... can use this formula to find out how many students scored higher than average how many employees are paid higher than the average how any sales reps made sales higher than the average ..........the list goes on - once you get an understanding of the syntax sky is the limit with … [Read more...]

- 1
- 2
- 3
- …
- 37
- Next Page »