Forum Discussion
Combining IF and AND formula applied to text strings.
Hi,
I would like to insert a combined IF and AND logical routine to return a result in another cell of "True" / "False" / or ideally a number when one cell = a text string eg. "TextA" and another cell = a text string "Text B"
I can use the IF and AND combination with numbers but the formula does not appear to accept cells with text strings. This is what I really want for part of a spreadsheet containing lots of text strings where the condition is if cell A2 = barrie and cell B2 = kirton , the result will show in cell C2 as true or false or ideally 1 or 2 .
Hope someone can help me.
Many thanks in anticipation.
Barrie Kirton
Is this possible or is there and alternative logical function I could use pe
7 Replies
Hi Barrie,
Excel definitely compares cells with text
- Sergei,
Many Thanks for your help, very much appreciated.
Is it possible in the Formula string to count the number of times "A2" and B2" = barrie (A2) and kirton (B2)and using COUNTIF and AND routines
I would like to count the number of times these two events occur in a spreadsheet with about 60 rows First Names and Surnames..
I know I can do this with the Data filter tool but would like to use COUNTIF and the AND routineBarrie,
You'd like to count number of such records for the specific name(s) you have in other cells; or generate the list of unique names from your A,B columns adding how many times such names are repeated?
