Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a couple of previous posts on formulas, I'm not great at tagging them together so if anyone can point me in the direction of a good way to learn this I would appreciate it. In my previous posts I was offered 2 formulas, actually I now need to use them together to say that if the first formula is true call it say "PT1" and if the second condition is true call it "PT2" My 2 individual formulas are =IF(AND(LEFT(F2,3)=RIGHT(F2,3),LEN(F2)=11),"yes"," no") - this is the one I would want to return PT1 The second one is.... ==IF(AND(LEFT(H53076,3)=RIGHT(H53076,3),LEN(H53076 )=19),"YES","NO") - this one would want to return PT2, and I also wanted to tag a condition to the second one to say the length should be 19 char. Is it possible to tag these 2 together and have the different answers, pt1,pt2, or NA for any others? Many thanks Paula |