You're dealing with ratios/percentages

You raised 505 by 709/505*100% which is 140.396%

So you want to raise the other numbers by that same %age

Your formula is 157 * 140.396% which is 220.4218
and 348 * 140.396% which is 488.5782

220.4218 + 488.5782 = 709


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=513311