A percentage formula?

Kevin

New member
Joined
Jan 9, 2019
Messages
1
Hello,
I was given a spreadsheet wherein someone had written the following percentage formula, (X+Y)/x*100=%

The idea is to find the percentage of good using the total "X" and bad "y".

It doesn't make any sense to me. What am I missing?
 
Hello,
I was given a spreadsheet wherein someone had written the following percentage formula, (X+Y)/x*100=%

The idea is to find the percentage of good using the total "X" and bad "y".

It doesn't make any sense to me. What am I missing?
What a mess!
You're showing 4 variables: X,Y,x,y : is that your intent?

Can you answer this:
A jar contains 120 red jelly beans and 30 black jelly beans.
What is the percentage of black jelly beans?
 
Hello,
I was given a spreadsheet wherein someone had written the following percentage formula, (X+Y)/x*100=%

The idea is to find the percentage of good using the total "X" and bad "y".

It doesn't make any sense to me. What am I missing?

They got it backward. If there are x of one thing and y of another, and you want to know what percentage of the total (x+y) are the first type (x), then the answer is x/(x+y) * 100%. That is, you divide the part by the whole.

For example, if there are 3 good apples and 7 bad apples, the percentage of good apples is 3/(3+7) * 100% = 3/10 * 100% = 30%
 
… someone had written the following percentage formula,

(X + Y)/x*100 = % …
Using the percent sign as a variable is "terriable". Using it as an abbreviation is abomination. :p
 
Top