is a somewhat unusual formula on several grounds, though possibly you have chosen to write it that way for reasons I don't understand:
- Expressions -2.75*10^1, 9.5*10^1, and 10^1 are used instead of the constants -2.75E1, 9.5E1, and 10E1
- RANDBETWEEN expects (see Help) integer arguments, but the first is -27.5 and will be rounded down, perhaps unexpectedly, to -28
- The result of RANDBETWEEN is divided by 10^1 and multiplied by .001 instead of just multiplying by .0001
I would have used =RANDBETWEEN(-28;95)*0.0001
. You don't need to explain why you did it your way, as long as you meant to use the more complicated calculation.
If you want to use RAND() instead of RANDBETWEEN() you can use =INT(124*RAND()-28)*0.0001
(124 is 95+28+1). This will recalculate when F9 is pressed.
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5. The locale for any menus or Calc formulas in my posts is English (USA).