Get your Math on

[finksmart]

I need a math formula that gives a random number outside of any given range. i.e. For a random number outside of 1-100, 101 - good, 99 - not good. Any math genius holla at cha boy!

 

[Keith P]

In excel: =(100+(INT(RAND()*100)))
This will give you a number between 100 and 200. You can change the second "100" to change the range.

 

[House of Laughter]

In excel: =(100+(INT(RAND()*100)))
This will give you a number between 100 and 200. You can change the second "100" to change the range.

:iamwithst

House

 

[finksmart]

Thanks Keith. I was actually looking to find the random # that's greater than say for example 100 or less than 1. That formula only takes care of the greater than 100 part.

I've figured it out though, with a little bit of coding for those that understand - Get a random number from a range greater than 100(max), get a random number from a range less than 1(min), put these two random numbers in an array, then pick randomly from the array and you have it. Not exactly a formula but it will do.

In excel: =(100+(INT(RAND()*100)))
This will give you a number between 100 and 200. You can change the second "100" to change the range.

 

[Keith P]

OK. Then try this:
Cell A1:
=(100+(INT(RAND()*100)))
Cell B1:
=((INT(RAND()*100))*-1)
Cell C1:
=INDEX(A3:B3,(INT(RAND()*(3-1)+1)))