conditional formula in every third row and last row.

  • Thread starter Thread starter ramana
  • Start date Start date
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))
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate random numberes using reference to the other cell. 7
Formula wanted. 1
Sum automatically every cell in multiple rows 1
Comparison of columns using Conditional Formatting 3
Find the number of the lowest filled row 3
Summing every 7 cells consecutively 4
RANDBETWEEN problems 7
Copy conditional formatting across column in the same row 2

Back
Top