Formula to calculate whole unit daily total based on weekly requirement

[Kimberly Welty]

If I need to produce 50 units in 7 days, I need to be able to calculate a daily qty. This must always return a whole unit. Clearly if you do a roundup formula they daily rate will come up with 56 units, but I need the days to adjust so that in total I always equal 50. I don't want all the unit volumes to only reduce the last (seventh) day, if possible.

Any thoughts?

Row Columns M N O P Q R S T
Weekly Total 50
2 8 8 8 8 8 8 8 56 ----- need N, O, P, Q, R, S to adjust down so that each say 7 and the total will be 50
3

If not an option, reduce S3 to be 2 so that the total still ends up being 50.

Any assistance would be greatly appreciated!
Kimberly

[avk]

Is it necessary to fig in rounding.
If not then simply using =$T$2/7

[Kimberly Welty]

AVK --- if I use that formula I get 8 whole units daily. By day 7 I end up with a total of 56 rather than the needed 50.

[avk]

Can you provide which figures require "M3" to "S3" plz enter manually.

[Kimberly Welty]

I am not sure what you are asking, sorry.

I have attached a document, let me know if that helps.
Kimberly

[JeteMc]

Please try pasting the following in cell M3 and then dragging the fill handle over to cell S3:

Please Login or Register  to view this content.

Let us know if you have any questions.