LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 138
Default If And Or Formula

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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"