How do I create an IF formula in Google Sheets?

0:43 21:43 Suggested clip Google Sheets IF & IFS Functions — Formulas with If, Then, Else, Else YouTubeStart of suggested client of suggested clip Google Sheets IF & IFS Functions — Formulas with If, Then, Else, Else

How do I do an IF formula in Google Sheets?

The IF function can be used on its own in a single logical test, or you can nest multiple IF statements into a single formula for more complex tests. To start, open your Google Sheets spreadsheet and then type =IF(test, value_if_true, value_if_false) into a cell.

How do you write an IF formula in Google Sheets?

For the first argument of the IF function, enter: B2=”West”. As with the other Google Sheets functions, you don't need to enter the address of the cell manually mouse click is enough. Then enter comma (, ) and specify the second argument. The second argument is a value that F2 will return if the condition is met.

What is the IF function in Google Sheets?

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.

What is the formula of IF function?

The IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to “pass” scores above 70: =IF(A1>70,”Pass”,”Fail”).

How do I create an IF THEN formula in Excel?

0:57 3:48 Suggested clip Building “If-Then” Statements in Excel : Advanced Microsoft Excel YouTubeStart of suggested client of suggested clip Building “If-Then” Statements in Excel : Advanced Microsoft Excel

Create Formula Field Button to Template for Sign in Google Drive For Free

Last updated on Sep 14, 2026

Try most popular PDF tools

Discover a full set of tools to handle any document task.

Edit PDFs

Make quick PDF edits online.

Sign

Add legally binding signatures.

Merge

Combine multiple PDFs.

Request signatures

Send a document for signing.

Convert

Transform PDFs into other formats.

Find form online

Browse the online forms library.

Rearrange

Change the order of pages.

Share

Send PDFs for review or editing.

Compress

Reduce PDF file sizes.

pdfFiller ranks among the best

pdfFiller is rated 4.6 out of 5 stars across 1,000+ G2 reviews.

Read all reviews

It's not often I even respond to satisfaction surveys because as a business owner seldom do I find a company that lives up to it's hype. However, I am more than pleased to say that PDF filler provides both an outstanding product and platform as well as stellar customer support. I am very happy to have found them and to engage them in my business activities.

Dan A

Very helpful!! Having this product on my day by day is being great. I convert a lot of documents from pdf to Word to review and compare documents. This make my work easier. Convert documents from pdf to word, very easy!! I would love to compare documents directly in the program, and not have to convert it to Word before it.

Maria M.