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