Splitting a number in a cell into 2 smaller numbers

Mattedwards2019

New Member
Joined
Jan 31, 2019
Messages
3
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,629
Office Version
365
Platform
Windows
In B58
=MIN(B56,10000)
& in B59
=MAX(0,B56-10000)
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
5,890
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 :)
 
Last edited:

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,755
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?
 

Forum statistics

Threads
1,085,255
Messages
5,382,603
Members
401,796
Latest member
meloanthony

Some videos you may like

This Week's Hot Topics

Top