round numbers carry balance

[gordo1046]

Need help rounding numbers and carrying the balance to another cell.
i have attached sheet.
Its a split sheet to know where to send cartons made to different states. I need all states except NSW to have a round number and the balance carried to NSW.

[JeteMc]

I feel as if this hasn't gotten any replies because there isn't enough information.
There are some red numbers in columns L:Q and AH:AM but no reason is given for why.
If they are incorrect then it would help to know what those numbers should be and why.

[gordo1046]

The numbers in red can be ignored these are just to let the planner know its urgent.

Basically we have an impute Column "H" which is a total number of cartons that gets divided by a percentage in columns "Z" - "AE" this then needs to be divided by column "E" , column "E" is a pallet size . The problem with the current sheet is we want round numbers in pallets in "T" - "X" and the balance cartons go into NSW "S".

[JeteMc]

It would seem to me that the formula for T8 could be:

Please Login or Register  to view this content.

Once that formula is pasted drag the fill handle over to X8 and then, while T8:X8 are still selected, drag the fill handle down to X14
The following could be pasted into S8 and the fill handle dragged down to cell S14:

Please Login or Register  to view this content.

You could check the output of the formulas to see that they return the values in column H by using the following:

Please Login or Register  to view this content.

Let us know if you have any questions.