Excel 2000

[Guest]

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.

 

[Lee Harris]

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.

A1 = "Leads", B1 = "Sales", C1="%age Sales"

A2 = 77, B2 = 19, C2 = B2/A2 (shows % of type 0.0 to 1.0)
OR
A2 = 77, B2 = 19, C2 = 100*B2/A2 (shows % of type 0 to 100)

or use the first method and format column C to type "percentage", which
leaves the data in the form 0.0 to 1.0, but displays it as a 0 to 100 scale

 

[Guest]

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.

 

[Guest]

Kim,

Enter the leads in Cell A1 and the sales in B1. Then enter the formula
=B1/A1 in the cell C1. Format the cell C1 as percentage.(Place your cursor on
cell C1 and then Format/Cells Number tab and select percentage.)

Alok

 

[mooncrawler]

If Leads is in A2 and Sales is in B2, in C2 you'll enter: =(A2/100)*B2