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?

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?

anonymous · Answer

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

anonymous · Answer

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

anonymous · Answer

Is there an excel function that will do that?

anonymous · Answer

let me open excel and look

anonymous · Answer

Thank you, I was able to create one.

anonymous · Answer

ok good Im not that familiar with excel