# PERMUT Function – Find # of arrangements in Excel, VBA, & G Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 6, 2023

This tutorial demonstrates how to use the PERMUT Function in Excel to return the number of permutations.

## What is a Permutation?

A permutation is the number of arrangements in which a certain number of items can be arranged. The order is significant.

## PERMUT Function

Let’s say there are 7 seats and 7 people, the PERMUT Function returns the number of ways these 7 people can be arranged.

``=PERMUT(7,7)``

## PERMUT Function – Limited Options

Let’s say we have 7 seats and 5 people that need to be seated. The PERMUT Function will return the number of ways these 5 people can be arranged.

``=PERMUT(7,5)``

## PERMUT Function – Limited Items

Let’s say we have 7 seats and 9 people. The PERMUT Function will return a #NUM! error as the number of items are less than the number of available options.

``=PERMUT(7,9)``

It is unrealistic to arrange 9 people when only 7 seats are available.