# Category Archives: Formulas

### How to Use the IF Formula in Excel, Part 2

As amazing as the IF formula is alone, it really comes into its own when used in groups. In our last post, we talked about how to apply discounts to customer quotes based on a set of criteria being met. This week we’ll introduce you to nested IF functions. Nested IF formulas help you calculate…

### How to Use the IF Formula in Excel, Part 1

Sometimes you need your data to tell you more. The IF formula as a function gives your data a voice and turns raw numbers into useful information. For example: Your wholesale company charges different rates depending on the size of bulk orders – customers who order more receive volume discounts. You want to quickly calculate…

### Excel PivotTable Percentage: Which Customers Are Costing You A Fortune?

Let’s suppose you have sales by state, and each state belongs to a sales region. What percentage of your sales come from each region? First, Set Up Your PivotTable

### Quick Tips for Calculating Percentages In Excel

Here are some techniques for calculating percentages. For these examples, we have a simple sheet of travel expenses and you are after the percentage results of prices going up or down for the total and for the individual months. Percent increase Let’s say you anticipate more travel the following year and want to know what…

### How to Calculate Percentage of Total in Excel

The Ins and Outs of Excel Percentage Formula

### Create a Gantt Chart in Excel

If you do any project management, you’ll eventually need to (or be asked to) create a Gantt chart

### The Power of Excel Array Formulas Part II

Use an array formula to attach an IF to a function that doesn’t have one

### The Power of Excel Array Formulas Part I

Use an array formula to create an IF statement that has two conditions

#### PRYOR+ 7-DAYS OF FREE TRAINING

Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.