Making the AND function look at only part of a cell entry
I am trying to identify different conditions that might exist with data using
an AND statement embedded in an IF statement. The cell entries in column K might contain the word "composite", but there will be many times when the cell will have other words as well, e.g. Composite class/Multi-managed. I've looked at other posts on the board and tried various wild card-type solutions but can't find a way to make the AND statement look at only part of the cell. =IF(AND(G2="dupe",I2="x"),"delete",IF(AND(G2="dupe ",K2="composite"),"delete",IF(N2="y","delete","")) ) Help would be much appreciated! Thanks. |
Making the AND function look at only part of a cell entry
Try using the search function. If the value is 0, it's found the text your
looking for. -- HTH, Barb Reinhardt "Cathy" wrote: I am trying to identify different conditions that might exist with data using an AND statement embedded in an IF statement. The cell entries in column K might contain the word "composite", but there will be many times when the cell will have other words as well, e.g. Composite class/Multi-managed. I've looked at other posts on the board and tried various wild card-type solutions but can't find a way to make the AND statement look at only part of the cell. =IF(AND(G2="dupe",I2="x"),"delete",IF(AND(G2="dupe ",K2="composite"),"delete",IF(N2="y","delete","")) ) Help would be much appreciated! Thanks. |
Making the AND function look at only part of a cell entry
Thanks very much. I combined search and isnumber and it works perfectly now.
"Barb Reinhardt" wrote: Try using the search function. If the value is 0, it's found the text your looking for. -- HTH, Barb Reinhardt "Cathy" wrote: I am trying to identify different conditions that might exist with data using an AND statement embedded in an IF statement. The cell entries in column K might contain the word "composite", but there will be many times when the cell will have other words as well, e.g. Composite class/Multi-managed. I've looked at other posts on the board and tried various wild card-type solutions but can't find a way to make the AND statement look at only part of the cell. =IF(AND(G2="dupe",I2="x"),"delete",IF(AND(G2="dupe ",K2="composite"),"delete",IF(N2="y","delete","")) ) Help would be much appreciated! Thanks. |
All times are GMT +1. The time now is 04:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com