• Wendy Ni

How to Use If, Then Formula in Google Sheets

Objective Advantages

What does it mean to work on cloud? It means data can easily stay up to date because information is automatically saved as it’s typed. Are you collaborating with a team? No problem, team members can work together in real-time from their phone, tablet, or computer (offline and online).


In this blog, we go over the if, then formula. IF function in Google Sheets can be used when you want to check a condition and then based on it, returns a specified value if it’s TRUE, or else return the other specified value.

Steps to Use If, Then Formula in Google Sheets

  • In Google Sheets, start with a sheet that already has (at least) two columns (in this example, one with names and the other with grades)

  • In the third column over (it should be empty for the result pass or fail), we can type in the following formula =IF(B2>65, "Pass", "Fail")

  • Side tip - the quotation marks are important, without them the Pass or Fail will not show (or whatever that you want to be printed)

  • What this formula means if the numbers in the grades column is greater than 65, it will result in True aka Pass, if the grade is less than - then it will result in a False aka Fail

  • Double click on the bottom right of the cell to apply the formula to the rest of the column

For a more visual tutorial, here is a video.

Check out this blog, changing negative numbers to positive nunmbers in Google Sheets.



#howto #google #analytics #data #googlesheets #sheets #dataentry #lists #tasks #datavalidation #organized #pass #fail #true #false #ifthen #bookkeeping #financialservices #accounting #financialgps

  • Grey LinkedIn Icon
  • Grey Facebook Icon
  • Grey Instagram Icon

©2019 All Rights Reserved 

Philadelphia, PA | New York City, NYC | hello@FinancialGPS.co