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
Bookmarks