In A1 =IF(ROW()<=$B$1,RANDBETWEEN(10,20),"")
In A2 &A3 =IF(ROW()=$B$1,RANDBETWEEN(10,20),"")

Copy these 3 cells down as far as you need.

--
Ian
--
"ramana" wrote in message
oups.com...
Hi everybody,

I wanted have a formula in every third row and in the last row
irrespective of whether its is the row that what I need. I think this
question is not so clear, so I'm giving one example here.

B1=26(can have any +ve integer value)
So now A1=If(B1=1,randbetween(10,20))
then I need A4=(B1=4,randbetween(10,20))
then I need A7=(B1=7,randbetween(10,20))
.
.
.
.
then A25=(B1=25,randbetween(10,20))
here is now the problem

Now I need A26=(B1=26,randbetween(10,20)) as B1=26, and it
should be the last cell for the result.
I don't have the problem in creating in every third row but I need the
last result depending on the B1 cell value.

can any body help me to solve this problem.

Thanks and Regards

Ramana