How to Calculate Sales Conversion Rate Formula in Excel

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.Overview Image of Sales Conversion Rate Formula in Excel


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.

Dataset 01

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)

Applying Formula to Find Sales Conversion Rate

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

Converting Data into Percentage Format

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

Initial Result of Sales Conversion Rate Formula

Final Result of Sales Conversion Rate Formula

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


Similar Readings


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.

Dataset to Find Percentage of Ticket Sold

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)

Applying Formula

  • After hitting ENTER, we get the value at F5The Sum Function here finds the total sold tickets as well as the total tickets.

Initial Result of Sales Conversion Rate Formula

Final Result of Sales Conversion Rate Formula

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

Junaed-Ar-Rahman

Junaed-Ar-Rahman

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed BSc in Biomedical Engineering from Bangladesh University of Engineering and Technology. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo