In B1 enter the formula:
=INT(RAND()*5+1)+5*(A1-1)

And enter any number in A1

Mangesh



"ramana" wrote in message
ups.com...
Hi every body,

I'm a new member in this group.
I have a Question regarding nesting of formulae in one cell.
Cell A1 can have any integer value between 1 to 100.
Then Cell B1 should have a formula such that it should return me a
value using random formula.
ex: if cell A1 = 1, then CellB1 shoud return a value between 1 to 5.
using random formula.

if cell A1=2, then cell B1 should return a value between 6 to10 using
random formula and so on..

I have tried this using if&lookup functions but I couldn't get through.

Can any body help me on this issue.

Regards

Ramana