Excel IF Function with Multiple Conditions: Data Handling

IF Function With Multiple Conditions in Excel

The syntax is like :

=IF( condition, value_if_true, value_if_false)

So there are 3 arguments, first is the condition lik a>b , second is the result if the condition result is true, 3rd argument is the result if the condition is false. e.g:

=IF(A1>B1,”A1 is greater”,”A1 is lesser”)

This explains the simple if with one condition but we have more conditions like we also have to check say the difference between the 2 numbers is > 30 of not then we will have to use nested if like:

=IF(A1>B1,IF(A1-B1>30,”difference is >30″,”difference is<30″),”A1 is lesser”)

So we have actually changed the result if true to another if statement like:

=IF(A1-B1>30,”difference is >30″,”difference is<30″)

So the result of first condition A1>B1 if it comes true then it will check the next condition

A1-B1>30 and similarly there are 2 results if this condition is true or false.

If we have to write this entire thing in vba code or any coding algorithm it will look like this:

If A1> B1 Then
      If (A1-B1 ) > 30 Then
         Msgbox "difference is >30"
      Else
         Msgbox "difference is <30"
      End if
Else
   Msgbox “A1 is lesser”
End if

Based on the code you can see how IF function is nested and how the conditions are being checked.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References