Split Amount Based on condition

[Abdur_rahman]

Hello again,

I am looking for help in a formula which will split amount based on conditions as mentioned below.

- Split amount by first amount in C16 cell
Example in this case: 2,814,761.01
Starting from 1,000,000.00 then 1,000,000.00 and finally this amount 814,761.01


- Discounts will be applied until the maximum spited amount
Example in this case:
1,000,000.00 * 0% as first amount
1,000,000.00 * 1% as 2nd amount
and finally 814,761.01 * 2% as final amount.

Note: the amount and percentages are dynamic and keep changing.

copy of ample file is attached for your reference.

[samba_ravi]

c17=MEDIAN(C16-B16,$C$13-B16,0)
Try this copy and paste towards right

[Abdur_rahman]

Thanks Samba,

By the way I am also from Hyderabad, india.

Thanks you for the solution.

[samba_ravi]

But your profile location shows "Saudi Arabia"

[Abdur_rahman]

Yes I am working Saudi arabia.

I have another issue with the same file let say if I have a value fix in B4 then C7 will be =MEDIAN(C16-B16,$C$13-B16,0) and B19 will be =B18*B17.

But if the B4 value is move then the value will be into the D20 in this case only no other value will be appear.

can it be possible please.