Hi,
I got a problem with a planning tool I've built to show how many extra
sales are needed each month by my teams to hit a target and then an
overachieveing target.

I've also applied a weighting to each team to allow for experience. My
problem occurs when I then try to add the overachieveing target (eg.
12%) and then apply the weighting to each team, every result is only
96.44% of what I expected it to be.

The sum I'm using to calculate each teams stretched target is
=sum(stretched plan number of sales*team size as a percentage of total
staff)*(1+weighting applied to that team, which is also a percentage)

Please help!


--
Homer J
------------------------------------------------------------------------
Homer J's Profile: http://www.excelforum.com/member.php...o&userid=26166
View this thread: http://www.excelforum.com/showthread...hreadid=395256