Calulating Sales Conversion Rate in Excel

[joemamma]

I am trying to calculate sales conversion in excel. I have 2,370 clicks and 44 sales. When I try to use this formula to calculate the conversion rate in excel: =C3(this cell is the 2,370clicks)/C8(this cell is the 44 sales)*100 I get some weird result that doesn't look like a real conversion rate (538638.36%). Any insight would be appreciated. Thanks.

 

[JackDanIce]

Your posting implies that 2,370 clicks generates 44 sales, so you want to find out how many sales a single click generates. Formula for this would be:

=C8/C7

And as a percetage

=C8/C7*100

 

[joemamma]

hello and thanks for the reply. i am looking for how many clicks it took to generate sales. I am using the formula you mentioned and I get this weird long percentage. Am I missing something? thank you.

 

[JackDanIce]

Mistake in formulas - I used C7 instead of C3

If it's how many clicks it takes to generate a single sale, then your formula should be:

=C3/C8

In other words, 44x = 2,370 so x = 2,370/44

If you want to know how many sales a single click generates, then the formula is the recipriocal of the above, i.e:

=C8/C3

In other words, 1 click = 44/2,370 sales

 

[joemamma]

yes. that looks much better. thank you so much for your help.

 

[JackDanIce]

You're welcome