All versionsGoogle SheetsIn Spanish: SI

IF in Excel & Google Sheets

Checks a condition and returns one value when it is true and another when it is false. The building block of almost every spreadsheet.

Syntax

=IF(logical_test, value_if_true, [value_if_false])

Example: Pass or fail by grade

Excel / Sheets · English

=IF(B2>=5, "Pass", "Fail")

Excel / Sheets · Español

=SI(B2>=5; "Pass"; "Fail")

Shows "Pass" when the grade in B2 is 5 or more, and "Fail" otherwise.

IF in Spanish

In Spanish Excel and Google Sheets, IF is called SI. It's the same function: files translate automatically when opened in another language. When you type it by hand, the name and the argument separator change.

	English	Spanish
Function	IF	SI
Separator	,	;
Example	=IF(B2>=5, "Pass", "Fail")	=SI(B2>=5; "Pass"; "Fail")

The separator depends on regional settings: Spanish versions usually use semicolons, but countries with a decimal point (like Mexico) may use commas.

Translate another formula

Arguments

logical_testRequiredThe condition to check, e.g. B2>=5.

value_if_trueRequiredWhat to return when the condition is true.

value_if_falseOptionalWhat to return when it is false. Default: FALSE.

IF FAQ

What is IF in Spanish?

In Spanish, IF is SI. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =SI(B2>=5; "Pass"; "Fail")

Does IF work in Google Sheets?

Yes. IF works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called SI. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.

How do I use IF with several conditions?

Combine it with AND or OR: =IF(AND(B2>=5, C2="Yes"), "Pass", "Fail"). For a chain of options (A, B, C…), IFS is easier to read than nested IFs.