Need help with IF THEN with a true result sending the input to a certain cell

[rudyeb]

I am trying to find a way to take an entered number in an If /Then function when true to have that number go to a certain cell.
If I enter the number 100 in A1, I want it to then put 100 into Cell B1, if the number entered is 500, then put 500 into Cell C1., if 1000 then put 1000 in D1 and so on. The numbers that can be entered are; 100, 250, 500, 1000, 2500, 5000, and 10000 so there would be 7 different cells to go to.

How would I go about doing this?

[CAntosh]

Try entering the formula below in B1, then filling right through H1:

=IF(MATCH($A$1,{100,250,500,1000,2500,5000,10000},0)=COLUMN()-1,$A$1,"")

EDIT: The below version handles errors better:

=IFERROR(IF(MATCH($A$1,{100,250,500,1000,2500,5000,10000},0)=COLUMN()-1,$A$1,""),"")

[Oppressed1]

Another way, insert a row so that everything you have on row 1 is instead on row 2. Enter:
B1=100
C1=250
D1=500
E1=1000
F1=2500
G1=5000
H1=10000

B2=if($a2=b$1,$a2,"")
and copy that over to H2.

You enter your value in A2.

Then you can adjust row 1 if ever needed, without changing formulas. The row 1 cells will be "hardwired" rather than formulas. You can also copy row 2 down to have multiple A values.

[Greg M]

Post deleted