LOL. Can't argue with that.

Bob

"Roger Govier" wrote in message
...
Give or take - it was time to go for a beer, so not worth quibbling over
<vbg

--
Regards
Roger Govier
"Bob Phillips" wrote in message
...
I make that 17.47%, not 17.5% :-(

"Roger Govier" wrote in message
...
Hi Mel

It sounds like the company want an increase in sales from 77,074 to
90,539
which is a 17.5% increase.
However, the contribution from Misc is to be ignored.
Since Misc contributed 12,514 the remaining reps contributed 64,56 to
the
years total.
In order to get 90,539 from this year's sales, those same reps would
have
to
have their contribution increased by 40% rather than 17.5%
So, substitute 0.4 in your cells C2:C9 and delete cell D10
--
Regards
Roger Govier