Percent of Two numbers

  • Thread starter Thread starter Allen
  • Start date Start date
A

Allen

Hello All,

How do i compute the percent of one number based off another

example:

A=5233 B=3401

What is the percentage of A that will equal to B. Can this be done by
using a formula.

Thanks for any help

Allen
 
Hi Allen,

If A is in cell A1 and B in B1 then enter this formula in C1;
=A1/B1 and then format cell C1 to % by clicking on the % icon and set the
number of decimal places by clicking on the "Increase Decimal" icon.
--
Ken Russell

| Hello All,
|
| How do i compute the percent of one number based off another
|
| example:
|
| A=5233 B=3401
|
| What is the percentage of A that will equal to B. Can this be done by
| using a formula.
|
| Thanks for any help
|
| Allen
 
Back
Top