Cell B2 =IF(B1="","",IF(B115,15,B1))
Cell B3 =IF(B1="","",IF(B1<=15,0,IF(B1<=20,B1-B2,IF(B120,5))))
Cell B4 =IF(B1="","",IF(B1<20,0,IF(B1<=25,B1-20,5)))
Cell B5 =IF(B1="","",IF(B1<=25,0,B1-B2-B3-B4))

"julie" wrote:

Hi,
Is there a way to distribute a large number? Basically, I want to be able
to plug "X" where X could be any postive integer into B1 and have excel
automatically distribute it such that the first 15 of X go into B2 and the
next 5 into B3 and the next 5 into B4 and all additional into B5, but if X is
only 5, then B1 would be 5 and B3 through B5 would all be 0.
Or if X is 17 then B2 would be 15 and B3 would be 2 and B4 and B5 would both
be 0.

Is this possible?