How to Use UNARY_PERCENT Function in Google Sheets

UNARY_PERCENT Function in Google Sheets
How to Use UNARY_PERCENT Function in Google Sheets – Sheetaki

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

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 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:

You can try it out by yourself.

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

 

 

How to Use UNARY_PERCENT Function in Google Sheets

  1. 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.

 

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

UNARY_FUNCTION in Google Sheets

 

  1. 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.

UNARY_FUNCTION in Google Sheets

 

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

UNARY_FUNCTION in Google Sheets

 

  1. 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.

UNARY_FUNCTION in Google Sheets

 

  1. 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.

UNARY_FUNCTION in Google Sheets

 

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

 

  1. 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. 🙂

 

0 Shares:
Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like