You've lost me. Are the numbers at the foot hard-values, or calculated by
Excel formulae?

What do you mean by lose the .175?

BTW, according to me, 6,703*1.175 is 7876 not 7874.

--
HTH

Bob Phillips

"Mel" wrote in message
...
I have a worksheet that calculates the new year budgets. The budgets are
a
specific percentage. So far, the total budget number is coming out
correct.
However, I need to disregard the sales for the misc rep. I'm not sure how
to
do this without losing my sum (90,539) or possibly the %Inc (.175). Could
anyone shed some light on this?
Thanks,
Mel


Rep Item % Inc Sales Budget (D2+(d2*C2))
1 Item X 0.175 6,703 7874
2 Item X 0.175 7,078 8315
3 Item X 0.175 7,183 8438
4 Item X 0.175 590 693
5 Item X 0.175 17,936 21070
6 Item X 0.175 6,347 7455
7 Item X 0.175 5,455 6408
8 Item X 0.175 13,268 15586
Misc Item X 0.175 12,514 14700
77,074 90,539