Split a number into multiple part with exact multiple of certain number

[shahidr100]

Hello
I have rates of product defined in cells as follows:
A B
Product1 7
Product2 20

In the month of April I have a value of 2660. Which means if I buy 380 pcs of this product in one month it will cost me 2660.
What I want is to divide 380 into whole month. I also have to check that it does not take the whole 30 days of month as Sat and Sun are holidays.
It must be divided into 15-20 parts approx. Each month it must be random.

How can it be done in excel using formula.

Thanks.

[shukla.ankur281190]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[shahidr100]

hello

Thanks for the reply.
I have attached the excel file with before and after sheet.

If you need more info, i'll definitely pass on.

Thanks.

[menem]

Does amount of each part on each day is manually entry ?
I mean it does not average or no formulate to calculate for each part , right ?


Regards.

[shahidr100]

Thanks for the reply.

Actually amount for each product in each month is fixed. Rates for product is fixed.

In the BeforeSheet Cell number P14 the amount 9475 is my total monthly (April in this case) sale of the products 1 to 6. I have divided the amount 9475 into 6 products.
Product 1 sale in April is 1900
Product 2 sale in April is 400
Product 3 sale in April is 4000
Product 4 sale in April is 1000
Product 5 sale in April is 1175
product 6 sale in April is 1000

I have to further divide each product's sale mentioned above into April month in different dates.
This is the point where I am stuck as rates of each product is fixed which cannot change.
Product1's qty is 380 which is fixed and known. Product1's sale in April is 1900 which is is fixed an known.
In how many parts do I need to divide 380 is what I need to calculate.


@Menem-- not the amount of each part is not a manual entry. In AfterSheet at cell location B3,
Product1's quantity is 20 and the rate of Product1 is 5/- per piece. Product qty is the thing which should be automatically generated
and as per the rates.

I hope I have made myself clear.