Target Percentage problem

**Ace_XL** · 09-18-2012, 01:00 AM

In the what-if analysis ..use 'Goal seek'

Set Cell: B9
To value: 20000 (say)
By changing cell: B2

Does this help? What version of Excel are you using? Your user profile does not indicate anything.

**jwongsf** · 09-19-2012, 10:59 AM

Hi Ace XL
I am using excel 2010, and I will try what you have suggested.
Thanks

**jwongsf** · 09-19-2012, 11:05 AM

Hi Ace Xl
That achevies the goal, however i do in incooporate this into the sheet without have to go through the process of setting this up every time. Is there a way. Sorry new to this
James