| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a random number generator in excel? | Excel Worksheet Functions | |||
| The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
| I need to create gift certificates in excel how do I number each . | Excel Worksheet Functions | |||
Linear Mode
