Website banner for SpreadsheetClass.com

Learn to automate and grow your business with spreadsheets

  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting
  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting
  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting

How to extend a formula in Google Sheets by using the ARRAYFORMULA function with the IF function

Written by Corey Bustos Updated on May 8, 2019 in

An example that shows how to extend a formula in Google Sheets by using the ARRAYFORMULA function with the IF function

Related Posts:

  • ARRAYFORMULA & 5 ways to apply a formula to an…
  • How to capitalize all letters in Google Sheets with…
  • How to make text lowercase in Google Sheets with the…
  • Capitalize the first letter of words in Google…
  • Using array formulas to apply a formula to an entire…
  • How to multiply in Google Sheets (Multiply numbers,…
Tweet Share Pin It Print

Welcome to Spreadsheet Class!

Corey Bustos

My name is Corey, I have been building spreadsheets for companies for over 7 years, I was a data specialist at an online school for 5 years, and I created this website to help people learn how to use spreadsheets.

Read More
  • Contact
  • About
  • Hire an expert
  • Video course
  • Formula cheat sheet
  • YouTube lessons
Example image of Google Sheets cheat sheet for sidebar
Free Dashboards image for the footer

Dashboard video tutorial

  • Hire an expert
Connect with me on LinkedIn
Free Cheat Sheet image for the footer
Copyright © 2023 Silver Sky, LLC. Silver Sky, LLC is a limited liability company headquartered in Colorado, USA. — Designed by WPZOOM
Contact
 
Privacy Policy
 
Terms and Conditions