Hello Excellers and welcome to another #formulafriday today let's look at a request I have had from a reader, and that is to insert the file path and name of the file in a cell on the front of a workbook (or the first sheet). This actually is a really useful piece of information, to know exactly where your file is saved either locally or in a network location. I use this a lot as would have a need to know if my files are locally stored or on a shared drive using multiple report folders on a … [Read more...]

## Formula Friday – Top 3 Reasons Not To Use Hard Coding In Excel Formulas

Hi Excellers, it is time for some more formula fun on #formulafriday. Today I want to share with you my Top 3 Reasons Not To Use Hard Coding In Excel Formulas If you want see see all of the blog posts in the #formulafriday series then you can click on this page right here. If you want MORE Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips. If you want to see all of the blog posts … [Read more...]

## Formula Friday – Calculate The Date Of The Nth Weekday Of The Month

Hello Excellers welcome to more #formulafriday fun, today let's look at a query that is a actually a widely used calculation for a lot of different scenarios- calculating a date of a certain weekday in every month. For example- Calculate the date if you get paid on the second Tuesday of every month I calculate the date of the issue of my Newsletter which is issued the First Tuesday of every month A meeting which occurs on the last Friday of every month The date of Thanksgiving in … [Read more...]

## Formula Friday – Show A Zero Not Negative Number After Calculating Stock Items – Two Methods

Hey Excellers, one of my favorite times of the week, #formulafriday time!. Today let's look at avoiding Excel displaying a negative number after a calculation of stock items in an itinerary. This again is another discussion I had with an Excel user recently, they only needed Excel to display a zero (rather than the actual negative value) if the result of the calculation of stock in and out resulted in a negative value. So, let's flex our formula fingers, as there were a couple of ways … [Read more...]

## Formula Friday – How To Make An Exact Copy OF An Excel Formula

Hello it is #formulafriday again, today let's look at how to make an EXACT copy of an Excel Formula. What do I mean by that?. Well, when you copy of formula and paste it to a new range of cells, like another location in your worksheet or workbook, well, Excel is really helpful and adjusts the formula. For example - =SUM(A1:A4) is copied to the Column C then the formula is adjusted accordingly to =SUM(C1:C4) If you do not want this helpful assumption by Excel then it is easy … [Read more...]

- « Previous Page
- 1
- …
- 5
- 6
- 7
- 8
- 9
- …
- 20
- Next Page »