enter a number if equal to another number

[malik]

hi

i have a worksheet number in cell A eg 6 and a number in cell B1 eg 100, i
want to have the number 100 in cell B2 to B5 automatically, the number in
cell A is always a single digit number but in cell B it is always two or
three digit number. can i do this? thanks

 

[John]

Hi
Not sure what you mean but if you put in B5 =B2, it does't matter what is in B2
it will be in B5
HTH
John

 

[muddan madhu]

A1 = 6
B1 = 100
B2:B5 = 100

reference the range B2:B5 =B1

 

[Bob Phillips]

Is this what you want?

=IF(ROW()<=$A$1,$B$1,"")

Enter in B2 and copy down.

 

[CurlyDave]

Quite a Vague question, what is the value if A1= 1 ?
the Choose function is pretty cool.

=CHOOSE($A$1,10,20,30,40,50,100)
if A1=1 then the formula result will be 10 because it picks the first
value
so
if A1 = 6 then the result will be 100, because 100 is the sixth value
in the formula