Excel 2000
The formula (Sales as a percentage of Leads) is:
A B C
1 Leads Sales Closure Rate
2 77 19 =B2/A2
Just format column C to show percentage (Format | Cells | Number). Copy the
formula down for as many rows as you need.
"Kim" wrote:
How do I get a percentage of two numbers? Example: I have 77 Leads and 19
Sales. I want to enter a function that will show the Percent of Sales
automatically.
|