I was trying to figure out a way to get a randomize toggle to work in Excel and am really chasing my own tail here and wondering if anyone had any good solutions.
Basically what I am looking for is a Check Box to check/uncheck to start a random function in a set of other cells. So that the cells will randomize when the check is on but will remain the same when the check is off. I basically started here:
A1: =IF(D1=TRUE,RANDBETWEEN(1,100),)
But this gives me the random value when checked but 0 unchecked. Using "" as the FALSE condition gives a blank cell, and other than creating a circular reference I kinda ran outta ways to go about this. Does anyone know a way to get this interaction to work. I am trying to avoid any VBA or Macro codes as I wanted this in a workbook given out and used by a wide range of skill levels and many would be unable to work/understand those.
Thanks!
Bookmarks