Random Number

[hsandeep]

Can a cell be triggered to 'generate' RANDOM NUMBER between 1 to 10 if a certain criteria is met else no random number should be generated.

A1=RANDBETWEEN(1,10) Now if B1=100 then A1 should generate RANDOM NUMBER between 1 to 10 & for B1<>100 A1=null.

Using Excel2007

 

[gaz_chops]

Try

=IF(B1=100,RANDBETWEEN(1,10),"")

 

[hsandeep]

Try

=IF(B1=100,RANDBETWEEN(1,10),"")

Actually, I want A1 to generate 'continous' random number as long as B1=100. I am a bit 'not sure' about the time-interval for managing 'generation' of random numbers. I hope you got my idea.

 

[gaz_chops]

Actually, I want A1 to generate 'continous' random number as long as B1=100. I am a bit 'not sure' about the time-interval for managing 'generation' of random numbers. I hope you got my idea.

Then I think you will need VBA!