Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Sort One Column or Multiple Columns in Excel
  • How to calculate current stock or inventory in Excel
  • How To Create Frequency Distribution in Excel
  • Data Series in Excel
  • Excel Frequency Function Example

References

  • How to get address of last cell in range in Excel
  • How to use Excel OFFSET function
  • Basic INDEX MATCH approximate in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Excel Advanced Lookup using Index and Match Functions

Data Validations

  • How To Create Drop-down List in Excel
  • Excel Data validation date in specific year
  • Excel Data validation require unique number
  • Excel Data validation don’t exceed total
  • Excel Data validation no punctuation

IF function: Description, Usage, Syntax, Examples and Explanation

by

What is IF function in Excel?

IF function is one of logical functions in Microsoft Office Excel that returns one value if the condition is TRUE, or another value if the condition is FALSE.

Syntax of IF function

The syntax for the IF function in Microsoft Excel is:

IF( condition, value_if_true, [value_if_false] )

IF formula explanation

condition
The value that you want to test.
value_if_true
It is the value that is returned if condition evaluates to TRUE.
value_if_false
Optional. It is the value that is returned if condition evaluates to FALSE.

Returns

The IF function returns value_if_true when the condition is TRUE.
The IF function returns value_if_false when the condition is FALSE.
The IF function returns FALSE if the value_if_false parameter is omitted and the condition is FALSE.

Example of  IF function

Let’s explore how to use the IF function as a worksheet function in Microsoft Excel.

Based on the Excel spreadsheet above, the following IF examples would return:

=IF(B2<10, "Reorder", "")
Result: "Reorder"

=IF(A2="Apples", "Equal", "Not Equal")
Result: "Equal"

=IF(B3>=20, 12, 0)
Result: 12

Post navigation

Previous Post:

CUBEVALUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

CLEAN function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to return blank in place of #DIV/0! error in Excel
  • How to use Excel NOT Function
  • Extract multiple matches into separate rows in Excel
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • IFS function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get days, months, and years between dates in Excel
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Get first day of previous month in Excel
  • Check If Two Dates are same month in Excel
  • Display Date is workday in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • Map inputs to arbitrary values in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel
  • Group numbers with VLOOKUP in Excel

General

  • Count cells that do not contain many strings in Excel
  • Currency vs Accounting Format in Excel
  • How to get original number from percent change in Excel
  • AutoFit Column Width, AutoFit Row Height in Excel
  • Subtotal by invoice number in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning