How to write nested if statements in Excel

Posted On May 30, 2020

This post shows how to write nested if statements in Excel

To write a nested if statement, write other if statements in place of true or false statements. For example:
=if(A3=A4,if(B3=B4,”True”,”False”),”False”)

Following is a more detailed explanation:

Excel if statements have the following syntax:

if (condition, TRUE, FALSE)

Condition defines what you condition you are testing. For example, you want to know if A1 is a negative value (less than 0), the condition would be A1<0. TRUE defines what you want Excel to do if the condition returns TRUE and FALSE defines what you want Excel to do if the condition returns false.