lundi 12 août 2019

Looking to display random percentages in a cell

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