Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If,And Question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If,And Question
=IF(AND(left(f2,3)=right(f2,3),len(f2)=11),"yes"," no")
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If,And Question
=IF(AND(LEFT(F2,3)=RIGHT(F2,3),LEN(F2)=11),"yes"," no")
-- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "Paula" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If,And Question
Hi Jarek and Max, This is a great help, appreciate you both taking the time
to answer. Many thanks Paula "Paula" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If,And Question
Welcome, Paula
-- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "Paula" wrote in message ... Hi Jarek and Max, This is a great help, appreciate you both taking the time to answer. Many thanks Paula |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If,And Question
any time, Paula
;-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Look up question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
VBA Question / | Excel Worksheet Functions |