Modifying Randbetween function

[andreascostas]

I am using randbetween(-10,10) to generate numbers, Occasionally I get a 0, is there a way to modify this so that I never get 0?

 

[Jonmo1]

Try
=RANDBETWEEN(1,10)*CHOOSE(RANDBETWEEN(1,2),1,-1)

 

[Rick Rothstein]

Here is another way...

=RIGHT(-1,1+(RAND()<0.5))*RANDBETWEEN(1,10)

and another way using one less function call...

=INDEX({-10,-9,-8,-7,-6,-5,-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10},RANDBETWEEN(1,20))

 

[andreascostas]

Great, thank you both very much. All three ways work !!