I want to create a formula that says, "if a cell in column D has the phrase "triple net", or if a cell in column D has the word "base" then take the average of the corresponding cells in column M." This is the formula I have come up with but it isn't working... any suggestions? Do I need the OR function?
=IF(OR($D:$D="*triple net",$D:$D="*base*"),AVERAGE($M:$M),"0")
Bookmarks