conditional formula in every third row and last row.

R

ramana

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))
 
I

Ian

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.
 
R

ramana

Hi Ian,

Thanks alot, I thiught many ways to solve this, I missed the small
logic what you did. Now my problem is solve.

Thanks and Regards

Ramana
 
Top