Excel + Google Sheets · IF

Let Excel decide for you

Returns one value if a condition is true and another if it's false.

The formula

=IF(B2>30, "Chase", "OK")

What each part means

B2>30The question
"Chase"If yes
"OK"If no

Example

Before

	A	B	C
1	Invoice	Days late	Action
2	#201	12
3	#202	45
4	#203	0
5	#204	31

After

	A	B	C
1	Invoice	Days late	Action
2	#201	12	OK
3	#202	45	Chase
4	#203	0	OK
5	#204	31	Chase

Step by step

Click cell C2.
Type the formula: =IF(B2>30, "Chase", "OK")
Press Enter.
Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.

Where it works

Every version of Excel
Google Sheets
Excel for the web (free)

The same formula in other languages

English IF
Español SI
Português SE

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

IFSStop nesting IF inside IF COUNTIFCount anything in one second AVERAGEIFAverage only what counts MINIFSThe minimum, with conditions SORTA ranking that sorts itself NETWORKDAYSWorking days left to the deadline