Excel 2000

K

Kim

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.
 
L

Lee Harris

Kim said:
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.
Click to expand...


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
 
B

BekkiM

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.
 
A

Alok

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
 
Top