I have a block of about a 100 cells on a Google Spreadsheet. Some of them contain the string
A. I want to randomly choose some of those and randomly replace them with one of
So, basically I want something like this:
if current_cell == "A": if random() > 0.2: -- proceed with probability 0.8 current_cell = random_choice(["B", "C", "D", "E"])
I tried writing a formula on the same cell with an
IF but that is going nowhere. How do I achieve this?