RANDBETWEEN question

[sjc21]

Hi there,

I've set up an Excel sheet to use for a sensitivity analysis in a spatial modeling exercise that I'm working on. I plan to vary values of each variable in the model by +-0.1 within my sensitivity analysis. So, if a value was set to 0.5 initially, during each run of the sensitivity analysis it will vary and be assigned 0.4, 0.5 or 0.6.

I had planned to use =RANDBETWEEN(40,60)/100 but I am realizing that I am getting values that range from 0.40 - 0.60 (so, I could get 0.41, 0.42, 0.43, etc). I only want to have three values available: 0.4, 0.5 and 0.6.

Any suggestions on how to fix this issue?

Thanks so much!

Cheers
Shannon

[NeedForExcel]

Here!

=CHOOSE(RANDBETWEEN(1,3),0.4,0.5,0.6)

Deep

[sjc21]

Thank you! I also just saw that I could use =FLOOR(RANDBETWEEN(40,60)/100,0.1).

So many ways to accomplish the same task.

Thanks again for your quick response!

Cheers,
Shannon

[NeedForExcel]

Glad it helped!!

Deep