I am looking to find a way in Google Spreadsheets to show a random percentage between 93% and 96%. This would include, 93%, 94%, etc up to 96% obviously.
I want this in a cell. I currently have:
=RANDBETWEEN(0.93,0.96)
I have also "format as a percentage" for that cell.
What it's displaying is 100%. Why 100%? I don't understand. Can somebody help me understand what I am doing wrong?
I have tried =RANDBETWEEN
code but it may be wrong.
=RANDBETWEEN(0.93,0.96)
Aucun commentaire:
Enregistrer un commentaire