In this article, we will demonstrate how to calculate **sales conversion rate formula** in Excel. We may need to calculate various types of calculations for business purposes and Excel helps us a lot by providing various functions and features. The following article will help you **calculate sales** conversion rate. We will use **Microsoft 365** to do all these.

**Table of Contents**hide

## Download Practice Workbook

You may download the following workbook to practice yourself.

## What is Sales Conversion Rate

The Sales Conversion Rate metric measures the effectiveness of the sales team at converting leads into new customers. Itâ€™s an important metric for aligning sales and marketing teams as both teams will use this metric to determine the quality of leads. The formula to calculate Sales Conversion Rate is:

**Sales Conversion Rate= (Number of Sales / Number of Leads) *100**

## 2 Suitable Examples of Sales Rate Conversion Formula

In the following sections, we will provide two examples based on the **Sales Conversion Formula**. The first one is the performance of representatives of a company while the second one is the example of sold and unsold tickets of a bus company.

### Example 1: Sales Conversion Rate Formula to Analyze Performance of Employees

We may use the Sales Conversion Formula to analyze the performance of a sales representative. It is also possible to find out the target achievement of an employee. The following dataset shows the number of attempts of representatives of a company and the corresponding sales.

We will follow the steps below to calculate the sales rate formula for each person in the dataset.

**Steps:**

- At first, we apply the following formula at
**E5**.

`=(D5/C5)`

- After that, we hit
**ENTER**to get the value and select**Percentage**as the number format in that cell.

- By doing that, we get the percentage value in
**E5.**

- Finally, we use
**the AutoFill feature**to fill the remaining cells.

**Read More: How to Calculate Percentage of Sales in Excel (4 Examples)**

**Similar Readings**

**How to Calculate Projected Sales in Excel (2 Easy Ways)****Forecast Sales Using Regression Analysis in Excel (3 Methods)****How to Forecast Sales in Excel (5 Easy Ways)****Forecast Sales Growth Rate in Excel (6 Methods)**

### Example 2: Sales Conversion Rate Formula for Percentage of Tickets Sold

Bus or train ticket-selling companies may need to calculate the percentage of ticket selling often and they may use the Sales conversion formula to find this out. For instance, we will use the formula for the following dataset.

We will follow the steps below to calculate the percentage of sold tickets of the above dataset by sales conversion formula.

**Steps:**

- First, we will apply the following formula at
**F5**.

`=SUM(C5+E5)/SUM(C5+D5+E5)`

- After hitting
**ENTER**, we get the value at**F5**.Â**The Sum Function**here finds the total sold tickets as well as the total tickets.

- Finally, we use
**the AutoFill feature**to fill the remaining cells in the same row.

**Read More: How to Calculate Sales Growth Percentage in Excel**

## Things to Remember

- The sales conversion rate is a percentage value. So we have to convert all the output into percentage format before finishing the calculation.

## Conclusion

We have discussed the ways to apply the **sales conversion rate formula in Excel** in the above sections. Hope this will be very helpful for you. Let us know your views and recommendations in the comment section. Have a good day.

## Related Articles

**How to Calculate Sales Mix with Formula in Excel****Calculate Sales Tax in Excel (4 Suitable Ways)****How to Calculate Sales Growth over 3 Years in Excel (2 Methods)****Calculate Average Sales in Excel (5 Simple Approaches)****How to Forecast Sales Using Historical Data in Excel (6 Methods)****Calculate Annual Sales in Excel (4 Useful Methods)****How to Calculate Sales Growth over 5 Years in Excel (3 Ideal Examples)**