How to Use Percentage in IF Statements in Google Sheets

Published on

I have written tons of advanced Google Sheets tutorials covering almost all of the important functions. This time, I’m sharing a basic tutorial for beginners. In this tutorial, I’ll explain how to use a percentage value in a logical IF statement in Google Sheets. For example, if a cell contains a value of 80%, I want an IF formula to return TRUE; otherwise, FALSE.

I hope you’re already familiar with the use of the Logical IF function in Google Sheets. If not, you can find some tutorials in the Resources section at the end of this guide. They will take you from basic to advanced use of the IF function.

Example of Using Percentage Values in a Logical IF Statement in Google Sheets

There are two methods you can follow to include a percentage in a logical test in Google Sheets. One is by directly using the percentage value, and the other is by using the decimal equivalent. Let’s start with the percentage value itself.

Example:

Example of using percentages in a logical IF statement in Google Sheets

I have a long price list of books in the range A1:D, where columns A to D contain the labels Book Title, Author, Price, and Discount. The available discount is listed in column D. Whenever a discount of 50% or more is offered, I want to mark those books for order in column E.

You can use the IF function to label such books with the text “Place the Order” in Column E. Here’s how you can use a percentage value in a logical IF statement in Google Sheets:

=IF(D2>=50%,"Place the Order","")

Apply this formula in cell E2, then copy and paste it down the column. Alternatively, you can use an ArrayFormula in cell E2, which will automatically expand down the column:

=ArrayFormula(IF(D2:D>=50%,"Place the Order",""))

As mentioned, there’s another method to include percentages in an IF statement. You can use the formula below to test percentage values:

=ArrayFormula(IF(D2:D>=0.5,"Place the Order",""))

Here, instead of 50%, I’ve used 0.5, which is the decimal equivalent of the percentage. If you want to test for 25%, the value in the formula would be 0.25.

Resources

Here are some tutorials to help you master the IF or IFS logical statements in Google Sheets.

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Count Consecutive Duplicates in Excel (Dynamic Array Formula)

Counting consecutive duplicates in Excel is useful for analyzing patterns, detecting repetitive sequences, and...

How to Break RANK Ties Alphabetically in Google Sheets

The RANK function in Google Sheets is commonly used to assign rankings to numerical...

Google Sheets: Highlight an Entire Column If Any Cell Has an Error

Google Sheets allows you to highlight an entire column if any cell has an...

Filter Top N per Category in Excel (Using FILTER & COUNTIFS)

You can use a combination of FILTER and COUNTIFS to filter the top N...

More like this

How to Break RANK Ties Alphabetically in Google Sheets

The RANK function in Google Sheets is commonly used to assign rankings to numerical...

Google Sheets: Highlight an Entire Column If Any Cell Has an Error

Google Sheets allows you to highlight an entire column if any cell has an...

Google Sheets: Extract Top N per Group from Query Aggregation

When working with grouped and aggregated data in Google Sheets, you might need to...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.