IF Function in Excel

Learn how to use the IF function for conditional logic. With AutoExel, you get automatic logic with AI.

What is the IF Function?

IF is one of the most used functions in Excel. It performs a logical test and returns one value if the condition is true, another if it's false.

Syntax: =IF(condition, value_if_true, value_if_false)

Check if a value exceeds a threshold

=IF(A1>100, "High", "Low")

Returns "High" if A1 is greater than 100, otherwise "Low"

Calculate bonus based on sales

=IF(B1>10000, B1*0.1, 0)

Gives 10% bonus if sales exceed 10000, otherwise 0

Nested IF for multiple conditions

=IF(C1>=90, "A", IF(C1>=80, "B", IF(C1>=70, "C", "F")))

Assigns grades based on score ranges

Too many nested IFs

With more than 3-4 nested IFs, consider using SWITCH or IFS functions for clarity

Upload your file and ask "Which sales are above target?" - AutoExel does the logic for you with AI.