Question

I have 3 numbers: 57, 5, 68. I know that 68 is 52% of the total. Is there an equation that I can use that will calculate what number 68 would become if I want it to be 65% of the total?

Answer 1

x/(57+5+x)=.65

x is the new number so you want it to be .65 of the total which is 57+5+x

Answer 2

x=40.3+.65x
.35x=40.3
x=115.14

check .65*(57+5+115.14)=115.14, so we are right

Answer 3

Is there an excel function that will do that?

Answer 4

let me open excel and look

Answer 5

Thank you, I was able to create one.

Answer 6

ok good Im not that familiar with excel