how will i create different number conbinations in ms excel?
When you say "different", do you really mean random?
To generate a random real number between a and b, use:
RAND()*(b-a)+a
To get the integer portion, use INT(RAND()*(b-a)+a)
--
Y
"heartangel" wrote:
my boss is asking me if i can do a different combination of number between
1-9 with the use of a formula.. i need your help to solve my problem.. thanks
guys...
|