Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula help - Is this possible?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |