Split the numbers

[Shi]

Hai Friends..

In my attached sheet..

If kgs are greater than 3000, then it has to split the numbers in same vehicle.. as shown in sheet 2.. please suggest me..

Thanking You

[shukla.ankur281190]

Try In sheet data.

D3=IF(C3>3000,INDEX(Sheet2!$C$3:$C$50,MATCH(Data!$B3,Sheet2!$B$3:$B$50,0)),$C3) and drag down.

[Shi]

Answer should be displayed in sheet 2.. what the data there in sheet 2 is answer.. we cant formula to that sheet

[amit.wilson]

Shi,

let's take vehicle number KA 20 AA 003 as an example. It has 17,690 kgs.

On Sheet2, this weight is distributed over 7 vehicles: 2945, 2880, 2690, 2955, 2895, 1660, 1665.

Is there a method or formula for dividing the weight? Seems random.

In the attached sheet, I've divided the weight equally (rounded to the nearest 10) with any residual extra going to the last vehicle.

Cheers

[shukla.ankur281190]

Try in Sheet 2

D3=IF(C3>3000,INDEX(Data!$C$3:$C$22,MATCH(Sheet2!B3,Data!$B$3:$B$22,0)),C3) and drag down.

[Shi]

Thank You Amith.. But the figure should be diferent.. In you formula 2950 same till 6 vehicle.. What I showed in sheet 2 like that answer has to be displayed.
KA 20 AA 003 2945
KA 20 AA 003 2880
KA 20 AA 003 2690 like that..

[Shi]

Thank You Shukla.. sheet 2 is the, I Just done it in manually.. main sheet is data.. like sheet 2.. data sheet has to be displayed

[amit.wilson]

Shi,

that's my question: how do you decide on what number to use? Is it a randomly chosen number? Or is there a formula or method for deciding the different numbers?

[Shi]

Amit,

randomly chosen.. we can choose any number below 3000

[Shi]

Amit,

randomly chosen.. we can choose any number below 3000