Bub_the_Zombie
Board Regular
- Joined
- Nov 1, 2016
- Messages
- 53
trying to make a formula that writes "out" in a cell if it reads an X in a different cell.
If M7 = x, then D7 = OUT
I was trying to convert an example from online to fit my needs, but no luck. Been googling around for about an hour, giving up and putting my request to the mercy of the boards. Can someone please show me how to write this please.
Was trying to convert this.
=IF(ISNUMBER(SEARCH("abc",B5)),B5,"")
I had
=IF(ISNUMBER(SEARCH("X",M7)),D7,"OUT")
Any help appreciated.
If M7 = x, then D7 = OUT
I was trying to convert an example from online to fit my needs, but no luck. Been googling around for about an hour, giving up and putting my request to the mercy of the boards. Can someone please show me how to write this please.
Was trying to convert this.
=IF(ISNUMBER(SEARCH("abc",B5)),B5,"")
I had
=IF(ISNUMBER(SEARCH("X",M7)),D7,"OUT")
Any help appreciated.