IF

Google-Sheets

Definition

Returns one value if a condition is TRUE, and another if FALSE.

Example

=IF(A1>100, "High", "Low") shows "High" if A1>100, otherwise "Low".

Related Terms

Browse Categories

Quick Navigation

Back to Glossary Absolute Cell Reference Add-on Apps Script

Stop Juggling Dashboards. Start Growing Get your data flowing today, free plan available.

Start Automating My Data