Hi. I am trying to create a formula that will display, in column C, the value in column A if column B contains "xb". If column B does not contain "xb", then the formula should display "0".
Example:
.....A......B......C
1...3......xb......3
2...2...............0
3...5......xb......5
Thanks!
Bookmarks