Excel Function

IF

Basic conditional branching function.

IF(logical_test, value_if_true, value_if_false)

Arguments

logical_test

Required

Enter a condition expression that returns TRUE/FALSE.

value_if_true

Required

Specify the value returned when the condition is TRUE.

value_if_false

Required

Specify the value returned when the condition is FALSE.

Practice Preview

Use IF to return "Pass" when cell C2 (Score in column C) is greater than or equal to 80; otherwise return "Fail".

Example Table

#	ALearner ID	BName	CScore
2	U001	Tanaka	82
3	U002	Sato	67
4	U003	Suzuki	91
5	U004	Takahashi	55
6	U005	Ito	78
7
8

How to Use (Formula)

=IF(C2>=80, "Pass", "Fail")

Result

Pass

Practice This Function

Start Function Practice Back to Function List

IF FAQ

How do I use IF in Excel?

Enter the condition, the value for TRUE, and the value for FALSE in order. For example, to label scores above 80 as Pass, use IF(C2>=80, "Pass", "Fail").

Where can I practice IF?

Use the "Start Function Practice" button to jump straight into IF drills.

What arguments does IF use?

The main arguments are Logical test, Value if true, Value if false. Enter them in order.