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.