Thread: Excel 2000
View Single Post
  #3   Report Post  
BekkiM
 
Posts: n/a
Default 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.