The UNARY_PERCENT function in Google Sheets is useful if you want to interpret a number into a percentage value.
Table of Contents
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
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 function is as follows:
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_PERCENTfunction where it will return a
PERCENTAGEis 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.
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
- 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. 🙂