get percent of number

[newapa]

Hi!

I wonder if there any formular that take out precent of 4 combin nr?
example 0 to 9 and the cell get a number and it will calculate out how many precent chance to get that number if its in random.

cell1         cell2         cell3       cell4        procent       
  3              2            8          4            0.0023%

thx in advance

 

[Asala42]

Does the order matter?
If it does, and you're asking what are the odds of getting a specific combination in a specific order (say as above, what are the chances of Cells 1-4 containing the random 0-9 results of "3,2,8,4"), isnt this just:

=(1/10)^4

The chances of finding the right number in cell 1 * chance of cell2, etc.

 

[pgc01]

Hi

How did you get the 0.0023%?

 

[newapa]

0.0023% just a sample
i just wrote something is not a correct data

 

[newapa]

Yeah order does matter.
ok yeah is what the odds is to get 3,2,8,4 in radom number. and the cell 5 will return the precent of it.
like the odds to get nr 3,2,8,4 is 0.0028 % chance to get that number in a row and its random 0-9 each cell.