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

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
"malik" wrote in message
...
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

A1 = 6
B1 = 100
B2:B5 = 100

reference the range B2:B5 =B1

"malik" wrote:

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

Is this what you want?

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

Enter in B2 and copy down.

--
__________________________________
HTH

Bob

"malik" wrote in message
...
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

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