| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
REQ: I need help working out this function.
I have a sheet with sales, stock and wks cover by 2 wks forward average
sales(asuming I don't get any more stock). N.B. figures are actual and estimated. Date Sales Stock wks cover (K) (K) wk1 200 800 3.5 wk2 220 750 2.9 wk3 240 720 2.4 wk4 280 760 2.2 wk5 310 790 2.1 wk6 390 840 2.5 wk7 350 890 2.9 wk8 320 940 - wk9 300 900 - What I need is to take away my sales estimates from my actual current stock cover to give a better figure because I have big sales peeks. Is this possible? Thanks -- Matt |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need help working out this function.
Two answers already in you multipost to Misc. Please stay in one newsgroup
to reduce wasted effort in people preparing duplicate answers. -- Regards, Tom Ogilvy Matthew Webb wrote in message ... I have a sheet with sales, stock and wks cover by 2 wks forward average sales(asuming I don't get any more stock). N.B. figures are actual and estimated. Date Sales Stock wks cover (K) (K) wk1 200 800 3.5 wk2 220 750 2.9 wk3 240 720 2.4 wk4 280 760 2.2 wk5 310 790 2.1 wk6 390 840 2.5 wk7 350 890 2.9 wk8 320 940 - wk9 300 900 - What I need is to take away my sales estimates from my actual current stock cover to give a better figure because I have big sales peeks. Is this possible? Thanks -- Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
| UDF Function Not working | Excel Discussion (Misc queries) | |||
| IF Function not working | Excel Worksheet Functions | |||
| IF function not working | Excel Discussion (Misc queries) | |||
| IF Function not working | Excel Discussion (Misc queries) | |||
Linear Mode
