Forum Discussion
Is there any way to apply random values to cells within Excel?
So at the start of a year, you want numbers that are a combination of user-entered values and random adjustments. With that clarification, it seems that you should use one column for the values you enter, and a separate column for the "tweaked" values (i.e., the values after the random adjustments). So putting the former into column B and the latter into column C, copy this formula from cell C2 down:
=IF( $A$1="TWEAK", B2 + ROUND(10*RAND()-5, 1), C2 )and use the special word "TWEAK" instead of "RESET".
I have just one follow-up question, and I'm fully aware that it's because I failed to adequately explain what I was looking for in my main post, which I apologise for. The way I've been doing it is that I've been adding smaller random values (-5.0 to +5.0) to each cell. How would I modify that formula so that it can do that, if it's at all possible?
So at the start of a year, you want numbers that are a combination of user-entered values and random adjustments. With that clarification, it seems that you should use one column for the values you enter, and a separate column for the "tweaked" values (i.e., the values after the random adjustments). So putting the former into column B and the latter into column C, copy this formula from cell C2 down:
=IF( $A$1="TWEAK", B2 + ROUND(10*RAND()-5, 1), C2 )and use the special word "TWEAK" instead of "RESET".
- Awesome, thank you so much! Apologies again for my failure to properly explain.