| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why doesn't my =RANDBETWEEN function work?
does anyone know why my =RANDBETWEEN(1,100) formular just returns error.
? I can't get it to work with any figures. I'm using Excel 2003. Sorry I can't give you any more information, I just can't get my randbetween function to work at all. I've tried going into INSERTFUNCTION etc. but I can't find it in the list either. hope you can help Daniel -- iPod's ROCK! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why doesn't my =RANDBETWEEN function work?
Do you have ATP installed (look under toolsadd-ins and Analysis ToolPak)
If not install it (you need the office/excel cd) -- Regards, Peo Sjoblom (No private emails please) "DanielWalters6" wrote in message ... does anyone know why my =RANDBETWEEN(1,100) formular just returns error. ? I can't get it to work with any figures. I'm using Excel 2003. Sorry I can't give you any more information, I just can't get my randbetween function to work at all. I've tried going into INSERTFUNCTION etc. but I can't find it in the list either. hope you can help Daniel -- iPod's ROCK! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why doesn't my =RANDBETWEEN function work?
Make sure that the Analysis ToolPak is installed.
-- Gary''s Student "DanielWalters6" wrote: does anyone know why my =RANDBETWEEN(1,100) formular just returns error. ? I can't get it to work with any figures. I'm using Excel 2003. Sorry I can't give you any more information, I just can't get my randbetween function to work at all. I've tried going into INSERTFUNCTION etc. but I can't find it in the list either. hope you can help Daniel -- iPod's ROCK! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why doesn't my =RANDBETWEEN function work?
"DanielWalters6" wrote:
does anyone know why my =RANDBETWEEN(1,100) formular just returns error. [....] Sorry I can't give you any more information I'm sure you can. The other respondents probably guessed correctly (you need to install the ATP). But for future reference, at a minimum, you should post the error message that you get. , I just can't get my randbetween function to work at all. I've tried going into INSERTFUNCTION etc. but I can't find it in the list either. hope you can help Daniel -- iPod's ROCK! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why doesn't my =RANDBETWEEN function work?
THANKYOU TO EVERYONE WHO SUGGETED INSTLLING THE ATP
IT'S NOW WORKING :) DAN -- iPod's ROCK! "Gary''s Student" wrote: Make sure that the Analysis ToolPak is installed. -- Gary''s Student "DanielWalters6" wrote: does anyone know why my =RANDBETWEEN(1,100) formular just returns error. ? I can't get it to work with any figures. I'm using Excel 2003. Sorry I can't give you any more information, I just can't get my randbetween function to work at all. I've tried going into INSERTFUNCTION etc. but I can't find it in the list either. hope you can help Daniel -- iPod's ROCK! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO YOU MAKE FORECAST FUNCTION WORK IN EXCEL? | Excel Worksheet Functions | |||
| Can't get SUM function to work in Excel 2000 | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| hOW DO I GET THE XCELL FUNCTION CUMPRINC TO WORK? | Excel Worksheet Functions | |||
| GCD Function doesn't work in some cases | Excel Worksheet Functions | |||
Linear Mode
