how will i create different number conbinations in ms excel?
 

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...

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...