Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDBETWEEN Not working
Help!!!
I am trying to use the RANDBETWEEN function. I have downloaded the analytic service pack. I am trying to use it with cells and not numbers. When I try it I get weird numbers for example, if C1 is 78 and D1 is 80 the formula RANDBETWEEN(C1,D1) constantly returns 1. If C1 is 135 and D1 is 150 then the same formula would contstantly return 2. Do I have to use specific numbers? Thank you for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDBETWEEN Not working
Also - does this function not work within another fuction (i.e. an IF
statement)? "tuxaby" wrote: Help!!! I am trying to use the RANDBETWEEN function. I have downloaded the analytic service pack. I am trying to use it with cells and not numbers. When I try it I get weird numbers for example, if C1 is 78 and D1 is 80 the formula RANDBETWEEN(C1,D1) constantly returns 1. If C1 is 135 and D1 is 150 then the same formula would contstantly return 2. Do I have to use specific numbers? Thank you for your help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDBETWEEN Not working
On Fri, 30 Dec 2005 09:58:02 -0800, tuxaby
wrote: Help!!! I am trying to use the RANDBETWEEN function. I have downloaded the analytic service pack. I am trying to use it with cells and not numbers. When I try it I get weird numbers for example, if C1 is 78 and D1 is 80 the formula RANDBETWEEN(C1,D1) constantly returns 1. If C1 is 135 and D1 is 150 then the same formula would contstantly return 2. Do I have to use specific numbers? Thank you for your help I cannot reproduce your results. I suspect that the contents of C1 and D1 are not what they appear to be. Are they the result of formulas? If so, what is the formula and its precedents? What is the format of the cells? What do you obtain with =RANDBETWEEN(78,80) ??? And RANDBETWEEN, like any other function, can work inside an IF function. --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDBETWEEN Not working
What you're trying to do should work. It works just fine on my Excel 2003.
Some things you might check a 1. The Analysis Tookpak is actually installed. Although, you'd probably get an error if it wasn't, but check anyway. 2. Is your spreadsheet set to auto-recalc? If not, try hitting F9 and see what happens. 3. Check the formatting for all cells involved. A custom format could have weird results. 4. Does this problem happen on other worksheets too? Or just this one? Not sure what else to suggest. Good luck. Elkar "tuxaby" wrote: Also - does this function not work within another fuction (i.e. an IF statement)? "tuxaby" wrote: Help!!! I am trying to use the RANDBETWEEN function. I have downloaded the analytic service pack. I am trying to use it with cells and not numbers. When I try it I get weird numbers for example, if C1 is 78 and D1 is 80 the formula RANDBETWEEN(C1,D1) constantly returns 1. If C1 is 135 and D1 is 150 then the same formula would contstantly return 2. Do I have to use specific numbers? Thank you for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
amount of working days per month | Excel Discussion (Misc queries) | |||
Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) |