Is there a way in Excel to randomly round up or down a float to an integer number? Possibly with 50% chance of rounding up.
Something like:
ROUND_RANDOM(3.6,0) = 3 ROUND_RANDOM(3.6,0) = 4 ROUND_RANDOM(3.6,0) = 4 ROUND_RANDOM(3.6,0) = 3
Aucun commentaire:
Enregistrer un commentaire