answersLogoWhite

0


Best Answer

If you have two numbers and want to find what percentage they are of each other, you can do some division. So for example, if you want to find out what percentage of 96 is 75, then you would divide 75 by 96 and format the result as a percentage. So if 75 is in cell A1 and 96 is in cell A2, then in another cell you would put the following formula:

=A1/A2

It will be 78%.

If you want to find what percentage of 75 is 96, then the formula would be:

=A2/A1

It will be 128%.

The numerical difference between 75 and 96 is 19. If you want to find what percentage of 75 or 96 19 is, then you divide the 19 by the 75 or by the 96. You could have a formula in a cell A3 which finds the difference between the two numbers first as follows:

=A2-A1

That will be 19.

Then to find what percentage of 75 19 is in another blank cell you would have the formula:

=A3/A1

To find what percentage of 96 19 is in another blank cell you would have the formula:

=A3/A2

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What formula do you use to get a percentage of 2 numbers?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you find the area of a triangle if it has 3 numbers?

The formula for the area of a triangle is A=(1/2)BH where B is the base, and H is the height. If it has 3 numbers, pick out the 2 that you need, the base and the height, and use the formula.


What 2 numbers add to 60 and multiply to -359400?

or is this question unfactorable and I have to use the quadratic formula??


How do you convert numbers to percent?

Formula- 2.6 as a percentage. 2 whole = 200% 0.6=60% 200+60=260 Answer-260%


What is the percentage between 2 numbers?

what is the percentage change from 92 to 86.5


What is the sum of the numbers 1 through 35?

To sum numbers 1 through N, use this formula: (1 + N)*N/2, so (1+35)*35/2 = 630.


What is 2 and a quarter percentage in numbers?

2.25% = 0.0225


What is the circumference of a circle with a radius of 8 feet?

use the formula 2(pi)r=16pi use the formula 2(pi)r=16pi use the formula 2(pi)r=16pi use the formula 2(pi)r=16pi use the formula 2(pi)r=16pi


What is circumference of a circle with a radius of 8 feet?

use the formula 2(pi)r=16pi use the formula 2(pi)r=16pi use the formula 2(pi)r=16pi use the formula 2(pi)r=16pi use the formula 2(pi)r=16pi


What is the sum of numbers between 10 and 20?

to find the numbers between two numbers use this formula and reblace the a with the smaller number and b with the larger number((b^2+b)/2-b)-((a^2+a)/2)so the answer is 135 not including 20 as part of the sum


What is the primeter square with 7.5m sides?

To find this answer, use the perimeter formula for a rectangle and plug in the numbers. (l+w)(2) (7.5+7.5)(2) 15(2) 30m


How do you find the sum of a set of numbers?

To find the sum of a set of numbers, you can use this formula: ∑ = (x)(x+1)/2 That is..... The sum = (The number of samples)(The number of samples + 1)/2 Example: What is the sum of all numbers between 500 and 1000? Assuming that we do not include 500 or 1000 in our answer, we have 498 numbers to add up. Let's put that into the formula.... ∑ = (498)(498+1)/2 ∑ = (498)(499)/2 ∑ = (248,502)/2 ∑ = 124,251 The Answer is 124,251


How to find a percentage?

/ The 2 numbers * By 100 and there is your answear!