RANDBETWEEN Not working

[Guest]

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

 

[Guest]

Also - does this function not work within another fuction (i.e. an IF
statement)?

 

[Ron Rosenfeld]

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

 

[Guest]

What you're trying to do should work. It works just fine on my Excel 2003.
Some things you might check are:

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