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
768
=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.