Hello Excellers, and welcome back to another #FormulaFriday #Excel formula tip in my 2021 Series. Today, I want to show you how to use the FORMULATEXT function to check if your cells contain the same Excel formula. Why would you need to do this?. Well, one of my subscribers needed to do exactly this. They needed an easy way to check formulas on multiple pages were using the same (correct) formula. In particular, the Sales Tax is being calculated correctly. Each of the worksheets in … [Read more...]
Formula Friday – Applying Names To Your Existing Excel Formulas.

Hi Excellers, #formulafriday time again. Welcome back to another blog post in my 2021 series. Today is a bit different, I want to share with you how to rename or apply names to formulas that you may already have in your Excel worksheet. Let's take a look at an example. So, for example, you have inherited a worksheet that calculates the Sales Tax applicable to your monthly sales. Currently the value for Sales Tax sits in cell G1. Now, I like to use named ranges in my formulas, (if … [Read more...]
2 Ways To Create An Ongoing Count Of Sales Orders – Excel Formula Friday Double Edition

Hi Excellers, hope you are having an Excellent day. It is time for some more #formulafriday Excel formula fun. Today I have a Formula Friday Double edition. That's right. Today I will show you how to create an ongoing count of sales orders we had in 2018. We will use two methods. Up to you which one you want to use. Both work equally well in Excel. So, this tip is based on a question from a subscriber. They wanted to have an ongoing count of orders … [Read more...]
A Formula To Check If You Have Extra Spaces In Your Data – Formula Friday
by Barbara

Welcome Excellers to another #FormulaFriday blog post in my 2021 Excel series. Today I am going to show you some Excel formulas. These are a great way to check if you have extra spaces in your Excel data that you need to clean up. Sometimes the data in cells looks identical like my barcodes in my sales extract. But, when you try to analyse the data you do not get the expected results. I will show you an example. I have a set of data below that I want to use in a VLOOKUP … [Read more...]
Calculate The Percentage Discount In Excel.
by Barbara

Hello Excellers, welcome back to another #FormulaFriday #Excel blog post in my Excel 2021 series. Do you need to know how what discount has been applied to a product?. If you need to calculate the percentage discount well it is really easy. Today's Excel excitement is inspired by not only January sales discounts, but a question from a subscriber. Original Price And Discount Price. So, if you know the Original product price and also the Discounted product price, we can get Excel do … [Read more...]
- 1
- 2
- 3
- …
- 33
- Next Page »