Syntax
PERMUTA(n, k)
| Parameter | Description |
|---|---|
| n | Parameter of the PERMUTA function. |
| k | Parameter of the PERMUTA function. |
Examples
PIN with repeats
Formula
=PERMUTA(10, 4)
Returns 10,000. There are 10,000 possible 4-digit PINs (0000-9999) when digits can repeat.
Binary strings
Formula
=PERMUTA(2, 8)
Returns 256. An 8-bit binary string has 256 possible values (2^8).
Dice outcomes
Formula
=PERMUTA(6, 3)
Returns 216. Rolling 3 dice has 6^3 = 216 possible outcomes.
Common Errors
#NUM!
Both arguments must be non-negative integers. Negative values return #NUM!.
#VALUE!
Non-numeric arguments return #VALUE!.
Tips
It's just n^k
PERMUTA(n,k) = n^k. You could also write =n^k directly, but PERMUTA makes the intent clearer in your spreadsheet.
Much larger than PERMUT
PERMUTA(10,4)=10,000 vs PERMUT(10,4)=5,040. Allowing repeats greatly increases the number of possibilities.
Password strength
Character set size raised to password length: PERMUTA(62, 8) shows there are ~218 trillion possible 8-character alphanumeric passwords.
Try PERMUTA in Viztab
Import your data and use PERMUTA with 370+ other formulas. No signup required.
Open Viztab