need a formula to split an amount over 3 cells evenly but not bigger then 10 per cell

[FranzzzNLD]

hi, im new to the forum and not skilled in excel so i tried to find a simple formula online but got lost in the forest of formula's
what i try to do is fairly simple.

i have an certain amount (lets say 23) in A2 that needs to be split over 3 cells (B2,C2,D2) B2 shows between 0 and 10, C2 shows bigger then 10 but not bigger then 20 and D2 shows everything bigger then 20. so in this example it would look like this:

A2=23... B2=10 C2=10 D2=3

[Pepe Le Mokko]

In B2

Please Login or Register  to view this content.

C2

Please Login or Register  to view this content.

D2

Please Login or Register  to view this content.

[Glenn Kennedy]

I think it's more than that... I read it that 17 would be 6, 6 & 5.... or 5.6667 in each. The original post is not clear.

[bebo021999]

In B2:

=MIN($A2*2-SUM($A2:A2),10)

Drag accross as far as getting zero

What in mind is 59=10+10+10+10+10+9 with every cell not bigger than 10 as per your thread title said

[FranzzzNLD]

Pepe Le Mokko..Thank u so much! it worked like a charm!!! awesome.

[Pepe Le Mokko]

Most welcome