software

If there a way to do this:

I want to make a sheet that when I input a number it breaks out into to
cells, for example:

I input 1200 in to A1

I want B1 to show 1000 of that and
B2 to show the remaining 200.

Thanks for the help

Felix--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile: www.excelforum.com/member.php...oamp;userid=31192
View this thread: www.excelforum.com/showthread...hreadid=508606
I don't know if you've given us enough information to cover all of your
possible scenarios.

Maybe something like this can get you started:

A1: 1234

B1: =INT(A1/1000)*1000
C1: =INT(MOD(A1,1000)/100)*100
D1: =INT(MOD(A1,100)/10)*10
E1: =MOD(A1,10)

Those formulas return 1000, 200, 30, and 4, respectively.

These also return those same values:
B1: =FLOOR(A1,1000)
C1: =FLOOR(MOD(A1,1000),100)
D1: =FLOOR(MOD(A1,100),10)
E1: =MOD(A1,10)Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=508606
That did not work but thank you for input, I'm sorry for not explaiing
enough.

Here is excatly what i am trying to do

I want to input a number into say in a1 of that number I want up to
1000 go to say b1 and everything over 1000 go into b2.
So if I input 1234, 1000 goes to b1 and 234 goes to b2.
If I input 989, 989 goes to b1 nothing goes to b2
etc...

Felix--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile: www.excelforum.com/member.php...oamp;userid=31192
View this thread: www.excelforum.com/showthread...hreadid=508606
OK, Felix....try working with this:

A1: (any number)

B1: =IF(A1gt;=1000,FLOOR(A1,1000),MOD(A1,1000))
C1: =IF(A1gt;=1000,MOD(A1,1000),quot;quot;)

Does that fit your situation better?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=508606Adjustment:

C1: =IF(A1gt;=1000,MOD(A1,1000),quot;quot;)
should be
B2: =IF(A1gt;=1000,MOD(A1,1000),quot;quot;)

Regards,
Ron

quot;nyrfanquot; gt; wrote in
message ...
gt;
gt; That did not work but thank you for input, I'm sorry for not explaiing
gt; enough.
gt;
gt; Here is excatly what i am trying to do
gt;
gt; I want to input a number into say in a1 of that number I want up to
gt; 1000 go to say b1 and everything over 1000 go into b2.
gt; So if I input 1234, 1000 goes to b1 and 234 goes to b2.
gt; If I input 989, 989 goes to b1 nothing goes to b2
gt; etc...
gt;
gt; Felix
gt;
gt;
gt; --
gt; nyrfan
gt; ------------------------------------------------------------------------
gt; nyrfan's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31192
gt; View this thread: www.excelforum.com/showthread...hreadid=508606
gt;

Perfect! Thank you so much Ron!
Wait not excatly.

When I input 2210 2000 is going to b1 and only 210 to c1

Felix--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile: www.excelforum.com/member.php...oamp;userid=31192
View this thread: www.excelforum.com/showthread...hreadid=508606
OK sorry but I'm now really confused.

I need upto 1000 to be in one cell, everything over in another. the
way itis not if I enter 2210, 2000 is going to one cell and the the
210, I need 1000 and 1210.

Felix--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile: www.excelforum.com/member.php...oamp;userid=31192
View this thread: www.excelforum.com/showthread...hreadid=508606Got it (finally)

A1: (any number)

B1: =MIN(A1,1000)
B2: =IF(A1gt;1000,A1-1000,quot;quot;)

I hope that helps.

Regards,
Ron

quot;nyrfanquot; gt; wrote in
message ...
gt;
gt; OK sorry but I'm now really confused.
gt;
gt; I need upto 1000 to be in one cell, everything over in another. the
gt; way itis not if I enter 2210, 2000 is going to one cell and the the
gt; 210, I need 1000 and 1210.
gt;
gt; Felix
gt;
gt;
gt; --
gt; nyrfan
gt; ------------------------------------------------------------------------
gt; nyrfan's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31192
gt; View this thread: www.excelforum.com/showthread...hreadid=508606
gt;
Hi!

Enter this in cell B1:

=IF(ISNUMBER(A1),MIN(1000,A1),quot;quot;)

Enter this in cell C1:

=IF(A1gt;1000,A1-B1,quot;quot;)

Biff

quot;nyrfanquot; gt; wrote in
message ...
gt;
gt; OK sorry but I'm now really confused.
gt;
gt; I need upto 1000 to be in one cell, everything over in another. the
gt; way itis not if I enter 2210, 2000 is going to one cell and the the
gt; 210, I need 1000 and 1210.
gt;
gt; Felix
gt;
gt;
gt; --
gt; nyrfan
gt; ------------------------------------------------------------------------
gt; nyrfan's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31192
gt; View this thread: www.excelforum.com/showthread...hreadid=508606
gt;

Perfect Ron, thank you so much.

And thank you Biff.

Felix--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile: www.excelforum.com/member.php...oamp;userid=31192
View this thread: www.excelforum.com/showthread...hreadid=508606