Formula problem

[SBuzzT]

The formula below tells excel to assign a value of PRO to anything with the value H-Nov-030-01.

How would I get the formula below to search for anything like H-(whatever)-(value less than 5)-(whatever)?

=IF(OR(A3="H-Nov-030-01"),"PRO",IF(A3="ZFC","COM","PGR"))

 

[SkipVought]

Hi,

IF the format is ALWAYS
[tt]
H-xxx-nnn-nn
[/tt]
where xxx is any text value and nnn and nn are numeric values, then test
[tt]
Left(A1,2)="H-"
VALUE(MID(A1,7,3))<5
[/tt]

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[SBuzzT]

I'm not sure how that whole formula is now supposed to look (I'm no excel expert, for sure). Could you show me the entire formula?

 

[SkipVought]

[tt]
=if(and(Left(A1,2)="H-",VALUE(MID(A1,7,3))<5),"PRO",.....)
[/tt]


Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[SBuzzT]

From

=IF(AND(LEFT(A1,2)="H-",VALUE(MID(A1,7,3))<5),"PRO",IF(A3="ZFC","COM","PGR"))

I get #VALUE! as a result now. The value I'm comparing against (trying to get a PRO result) is H-Nov-000-01.

 

[AnotherHiggins]

Do you mean to go from A1 to A3 in your referenced cells?


[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.