View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Activating Function

What happens when you hit <F9?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nat" wrote in message
...
I just used the Add-In tool to activate additional spreadsheet function. I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't active,
i.e. the cell displays the number "1" and when I use the cell as a
multiplier
it multiplies by one. In other words, the cell isn't functioning by giving
me
random numbers between 0.9 and 1.1.

I suspect that there is some sort of "activation" key combination that I
have to hit to get the function to operate - but I don't know what it is.