"Kim" wrote in message
...
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