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
