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

**memo08** · 05-03-2023, 02:29 AM

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?

**AliGW** · 05-03-2023, 02:31 AM

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

**memo08** · 05-03-2023, 02:38 AM

i just attached the file and erased the screenshot

**AliGW** · 05-03-2023, 02:44 AM

Unclear - is this what you want?

=ROUND(SUM(C2:C7),1)

**bsalv** · 05-03-2023, 04:41 AM

you give everybody the same and if there is a remaining , give it to those with the greatest cost.

**AliGW** · 05-03-2023, 05:04 AM

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...mbers.1236263/)

**josephteh** · 05-03-2023, 05:59 AM

This formula is rather long:

PHP Code:


=ROUNDDOWN($A$12/$B$12,2)+IF(B2=MAX($B$2:$B$7),ROUNDDOWN(ROUND($A$12-$B$12*ROUNDDOWN($A$12/$B$12,2),2)/COUNTIF($B$2:$B$7,MAX($B$2:$B$7)),2),0)+IF(AND(COUNTIF($B$2:$B2,MAX($B$2:$B$7))=1,B2=MAX($B$2:$B$7)),ROUND(ROUND($A$12-$B$12*ROUNDDOWN($A$12/$B$12,2),2)-COUNTIF($B$2:$B$7,MAX($B$2:$B$7))*ROUNDDOWN(ROUND($A$12-$B$12*ROUNDDOWN($A$12/$B$12,2),2)/COUNTIF($B$2:$B$7,MAX($B$2:$B$7)),2),2),0)

1st difference apportioned among products with highest Cost. Next, any remaining difference to 1st product on the list with highest Cost

**memo08** · 05-03-2023, 12:58 PM

Thanks for the helpp

**memo08** · 05-03-2023, 12:59 PM

thansk for the helpp this was very helpfull

**memo08** · 05-04-2023, 01:31 AM

Hello this is a continuation of my last thread distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells

I need to distribute The total shipping cost equally on each shipping cost Cell, taking n count this time that the Total shippping cost is linked to anTrackID, and therefore the Products al linked to it.

i have in cell D2 the old formula but it have to be update.

**AliGW** · 05-04-2023, 01:33 AM

I have closed your follow-on thread - please continue here. I have copied your post here (see above).

**memo08** · 05-04-2023, 01:44 AM

Originally Posted by bsalv

you give everybody the same and if there is a remaining , give it to those with the greatest cost.

Hello again, can you please help me with the continuation of the thread ?

**AliGW** · 05-04-2023, 01:51 AM

Please be patient - remember that your helper is in a completely different time zone to you and is probably only just eating breakfast!

**memo08** · 05-04-2023, 01:56 AM

Of course, thx

**bsalv** · 05-04-2023, 03:29 AM

hello,

Please Login or Register  to view this content.

**memo08** · 05-04-2023, 04:18 AM

Hello thanks a lot, but i think i forget detailing more

Every TRACKID will have a differente value (it not will be cost just one value, in this case 14.60)

Example:

TRACKID

TBA001 ---> 14.60 and it will be split equally on every product under this unique trackID
TBA002 ---> 5.20 and it will be split equally on every product under this unique trackID
TBA003 ---> 2.85 and it will be split equally on every product under this unique trackID

Thats why i manage my little inventory and every box came with a unique TrackId, certain amount of products in every box and with different shipping cost per box. So i divide equally the shipping cost of each box on each product that came inside the box

**bsalv** · 05-04-2023, 06:45 AM

hello,
now with an extra table for your shipping costs

**memo08** · 05-04-2023, 11:25 AM

Originally Posted by bsalv

hello,
now with an extra table for your shipping costs

Thanks for the help, you are a GOD !!

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

LinkBack

Thread Tools

Rate This Thread

Display

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

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

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

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Re: Distribute automatically and equitly on EXCEL, in a certain number of cells, the resu

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Distribute number in one cell evenly across 5 other cells (round up if necessary)

Distribute number across cells

[SOLVED] distribute number on excel cell according to value

Hello, how to distribute content to a cell by various cells automatically.

Evenly distribute a number across several cells

[SOLVED] Distribute contents of a cell into other cells according to number of characters

Macro to Divide a Data in Cells and Distribute to X number of Columns

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions