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 |
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 |