The UNARY_PERCENT function in Google Sheets is **useful if you want to interpret a number into a percentage value.**

##### Table of Contents

The `UNARY_PERCENT`

does this simply by combining the syntax together with a number, or if the number is in the cell, you can just click the specific cell.

You may not find the `UNARY_PERCENT`

function necessary, but inevitably it comes handy, especially when working on complex or large data spreadsheets.

Let’s take an example to understand this function better.

Say, for example, you are in charge of preparing a budget for your department. The management allocated $50,000 for your department’s needs, and you have to supply a budget report.

**So how do we do that?**

Simple. First, we identify our department’s necessities and arrange them according to priority. Then, we can use the `UNARY_PERCENT`

function to convert the numbers into percentage values. Then, we will now multiply the percentage value with the said budget to arrive at a certain amount per need.

See how easy that is?

Another example that the `UNARY_PERCENT`

function may be helpful is when we deal with financial and/or loan calculations using functions like `PMT`

, `IPMT`

, `PPMT`

, and so on. We can have the `UNARY_PERCENT`

nested in those formulas for you to arrive at a precise answer in an instant.

Let’s dive into real-business examples where we will deal with actual values and textual strings to appreciate the concept and how we can write our own `UNARY_PERCENT`

function in Google Sheets to compute those data.

## The Anatomy of the UNARY_PERCENT Function

So the syntax (or the way we write) the UNARY_PERCENT function is as follows:

=UNARY_PERCENT(percentage)

Let’s break this down to understand better what each of the terms means:

the equal sign is just how we start any function in Google Sheets.`=`

`UNARY_PERCENT()`

is our`UNARY_PERCENT`

function where it will return a`PERCENTAGE`

value.`PERCENTAGE`

is the value that we want to interpret as a percentage (e.g. 20, 40, 100, or a selected cell in a sheet that contains a number)

## A Real Example of Using UNARY_PERCENT Function

Take a look at the example below to see how `UNARY_PERCENT`

functions are used in Google Sheets.

In the example above, the `UNARY_PERCENT`

is used to convert the numbers in **column D** into percentage values. We then multiplied the allocated budget with the `UNARY_PERCENT`

** value** to arrive at the allocated amount. Since our allocated budget of $50,000 is constant, we made use of the dollar ($) symbol to make it absolute.

=$B$2*unary_percent(D2)

Here’s what this example does:

- We have listed in
**column C**as particulars all the marketing activities that our marketing department will take on. We also specified the percentage value for each activity, as seen in**column D**. - Then, we have selected the cell
**E2**to make it an active cell. This is where we wrote our formula. - We started our formula with an equal sign ‘
**=**‘ followed by an opening parenthesis ‘**(**‘ and the cell**B2**. - Since we wanted to make
**B2**absolute, we added a dollar sign ($) before the letter B, and another dollar sign before the number 2 (**$B$2**). - Now, we multiply
**$B$2**with the percentage value. Since the percentage in column D are presented in numbers, we, therefore, need to transform them by using`UNARY_PERCENT`

. - Close the formula with a close parenthesis ‘
**)**‘, then hit on the**Enter**key. - Make sure your formula should look like this: =
**$B$2*unary_percent(D2****)**, before dragging it down to**E7**.

Super easy, right?

You may make a copy of the spreadsheet using the link I have attached below:

Let’s begin writing our own UNARY_PERCENT function in Google Sheets.

## How to Use UNARY_PERCENT Function in Google Sheets

- Simply click on an empty cell to make it active. This is where we will write our formula. For this guide, I selected the cell
**E2**.

- Start your formula with an equal sign ‘
**=**‘, just how we start any other function in Google Sheets.

- Next step, we will then select the cell
**B2**. Since we will multiply this same amount with a percentage value, let’s make it absolute by adding a dollar sign ($) before the letter B, and before the number 2.

- Then, we will use an asterisk sign (
*****). This denotes a**multiplication**operation.

- Since we want to multiply the
**allocated budget**with a percentage value, and the percentage values in**column D**are presented in numbers, we will then convert them into percentage using our function. So, for the fifth step, we will write our function, followed by an open parenthesis ‘**(**‘. Wait for the auto pop-up message, as this will act as our extra guide in writing our formula.

- The numbers are already written in the cells found in column
**D**. All we have to do is to just select them. In this step, we will select the cell**D2**.

- We will now close our formula with a close parenthesis ‘
**)**‘. Then hit on the**Enter**key.

- Let’s now drag our formula until we reach the cell
**E7**.

That’s pretty much it. You can now use the UNARY_PERCENT function together with the **other numerous Google Sheets formulas** to create even more powerful formulas that can make your life much easier. 🙂