Excel formula [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,



okay, say i had six new customers and out of six i closed three on a sale.

that is closing 50% of customers.

so, if V12=6 AND X12=3 how would i get Y12 to equal 50%

what would the formula be?

2 replies


While I can't entirely say for sure, based on what you are saying it seems like you want:
X / V * 100 and then a % at the end
So if I'm understanding correctly, X = customers closed on and V = total number of customers, and Y = percentage closed on. However since it is a bit early for my timezone right now, I may not be quite awake, but customers closed on (divided by) total customers (multiplied by) 100% will give you what you're looking for, however I'm more use to programming than excel so getting the percent sign will be someone else's job :)
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
=x12/y12

and format that cell as percentage. If it is whole column like that then just select the whole column and apply the format.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!