If,And Question

  • Thread starter Thread starter Paula
  • Start date Start date
P

Paula

Hi, I have 2 conditions in an IF formula and I am not familiar with the and
function but I would like to know how to link the 2 formula conditions in one
big formula.
The formulas I have are..
=IF(left(f2,3)=right(f2,3) this is my first formula
second one is =IF(len(f2)=11

I have a line of data and I want to say if the first 3 characters match the
last 3 characters and the length is 11 char. long say yes, otherwise say no,
I don't know how to do this all in one formula, would appreciate your help?

Many thanks

Paula
 
Hi Jarek and Max, This is a great help, appreciate you both taking the time
to answer.

Many thanks

Paula
 
Back
Top