Excel formula
Closed
m.c
-
Jun 14, 2010 at 02:34 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2010 at 05:31 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2010 at 05:31 AM
Related:
- Excel formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
2 responses
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 :)
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 :)
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 14, 2010 at 05:31 AM
Jun 14, 2010 at 05:31 AM
=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.
and format that cell as percentage. If it is whole column like that then just select the whole column and apply the format.
