Distribute automatically and equitly, in a certain number of cells, the result of the division of two numbers

[memo08]

Ok this is my problem.

I have the an total shipping cost( in this example 14.6) that normallys is a decimal number. This number have to be divide by the quantity of products that cames in a box( in this example 6). Giving a result of 2.433333

I have to complete the Shipping cost column equally with the result already mentioned. But by only taking into account the rounded number 2.43 (because we are talking about money) it leaves me out the decimal number 0.02, which in this case could not leave out since we are talking about money.

Therefore the sum of the shipping cost gives me 14.58 and not 14.60

What would be the formula that I should implement to solve this problem?

Libro1
	A	B	C	D
1	Products	Cost	Shipping Cost	TOTAL
2	Product A	19.99	2.43
3	Product B	19.99	2.43
4	Product C	160.99	2.43
5	Product D	160.99	2.43
6	Product E	12.95	2.43
7	Product F	12.95	2.43
8			14.58
9
10
11	Total of shipping cost	Quantity of product	Shipping cost for each product
12	14.6	6	2.433333333
Hoja1

Cell Formulas
Range	Formula
C8	C8	=SUM(C2:C7)
C12	C12	=A12/B12

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Distribute automatically and equitly on EXCEL, in a certain number of cells, the result o

Ok this is my problem. I have the an total shipping cost( in this example 14.6) that normallys is a decimal number. This number have to be divide by the quantity of products that cames in a box( in this example 6). Giving a result of 2.433333 I have to complete the Shipping cost...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.