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 B, C, D or E.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?
Randomly Replace Text in a Cell in Google Spreasheet
google spreadsheets