REQ: Need help with function...

M

Matthew Webb

Hi, can anyone help???


I have a sheet with...

Sales Stock Weeks
Est. Total Cover

220 1000 3.6
250 1100 3.9
300 1150 4.3
280 1050 4.2
-----
1050
-----
270 1075
280 1075
250 1100
220 1200
-----
1020
-----
200 1250

Cover is worked out by taking away the next weeks sales estimate until
less than a week and dividing the remainder to get part week.

Example...

1000-250=750
750-300=450
450-280=170
170/270=0.62

....so Wks Cover is 3.62(3.6 1dp)

N.B. There will be month totalling just in case the answer uses an
array. Might make it a little more difficult...

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

REQ: I need help working out this function. 2
3-D Line -- X,Y,Z 2
I need to look for a number and return the column heading. 6
REQ: I need help working out this function. 1
Bug in excel 2003 - trendline equation? 5
Apple Iphone 16GB 3G PLAY STATION 3 60GB LAPTOP 1
If time Go to Function 1
ALL KIND OF LAPTOP,PLASMA TV CDJ-100S Professional CD Player Play station games BlackBerry Curve 1

Top