Splitting a number in a cell into 2 smaller numbers

[Mattedwards2019]

Hi all , in cell B56 i have 13,857 which is a sum of B2:B53 and im looking to split this down into 10,000 into cell B58 then the remainder into cell B59 . Any ideas on what function i would use to do this? Thanks!

 

[Fluff]

In B58
=MIN(B56,10000)
& in B59
=MAX(0,B56-10000)

 

[gaz_chops]

In B58 enter

=MIN(10000,SUM(B2:B53))

In B59 enter

=MAX(0,SUM(B2:B53)-D58)

Fluff's is neater, forgot B56 had sum in it

 

[pgc01]

Hi

Will you have numbers bigger than 20000?

In that case what would you want in B58?

For ex., for 54321 would you want 10000 or 50000?