vendredi 17 juin 2022

Generate two false Booleans every ten rows in excel

I need to add a column to my spread sheet that generates two "false" at random intervals every ten frames.

So for example rows 1 though 10 could read:

  1. true
  2. true
  3. true
  4. False
  5. true
  6. false
  7. true
  8. true
  9. true
  10. true

and then repeat that for rows 11 through 20, but the false are randomly put in different places. etc. I want write a formula that does this for me.




Aucun commentaire:

Enregistrer un commentaire