We discussed in the last post what it means to first put your conditional into an English sentence and then translate that into an Excel IF formula. But what if the answer you want returned needs to use other cells' values?
Say, for instance, we had two columns of values. Our English sentence would go something like,
If both values are positive, then return the sum of the values; otherwise, just return the largest of the two values.
In Excel, this would translate to
Looks complicated, but take it piece by piece!
both values are positive = AND(N7>0,O7>0)
return the sum of the value = N7+O7
return the largest of the two values = MAX(N7:O7)