Can anybody help me out with a formula....

See below
A B C
D E
04 01 ++++++++ 01 03

I am trying to build a statement that says if C = ++++++++ and E = 03
then return VC, if C = ++++++++ and E = 02 then return PC otherwise
return OK

I tried this but I cannot get it to work
=IF(AND(C2="++++++++",E2="03"),"VC",if(C2="+++++++
+",E2="02"),"PC","OK")

Any help will be appreciated!!

Hi,

Try this

=IF(AND(C2="+++++++",E2="03"),"VC",IF(AND(C2="++++ +++",E2="02"),"PC","OK"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Cheekyaardvark" wrote in message
...
Can anybody help me out with a formula....

See below
A B C
D E
04 01 ++++++++ 01 03

I am trying to build a statement that says if C = ++++++++ and E = 03
then return VC, if C = ++++++++ and E = 02 then return PC otherwise
return OK

I tried this but I cannot get it to work
=IF(AND(C2="++++++++",E2="03"),"VC",if(C2="+++++++
+",E2="02"),"PC","OK")

Any help will be appreciated!!

Hi,

Instead of 7 +'s, use 8

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Cheekyaardvark" wrote in message
...
Can anybody help me out with a formula....

See below
A B C
D E
04 01 ++++++++ 01 03

I am trying to build a statement that says if C = ++++++++ and E = 03
then return VC, if C = ++++++++ and E = 02 then return PC otherwise
return OK

I tried this but I cannot get it to work
=IF(AND(C2="++++++++",E2="03"),"VC",if(C2="+++++++
+",E2="02"),"PC","OK")

Any help will be appreciated!!

Try this amendment:

=IF(AND(TRIM(C2)="++++++++",E2="03"),"VC",IF(AND(T RIM(C2)="+++++++
+",E2="02"),"PC","OK"))

Another thing to check is that the numbers in E are text values, and
not numbers that have been formatted to show a leading zero. This
variation might do the job:

=IF(AND(TRIM(C2)="++++++++",--E2=3),"VC",IF(AND(TRIM(C2)="++++++++",--
E2=2),"PC","OK"))

Hope this helps.

Pete

On Aug 5, 10:29*am, Cheekyaardvark wrote:
Can anybody help me out with a formula....

See below
A * * * * * * *B * * * * * * * * * *C
D * * * * * * *E
04 * * *01 * * *++++++++ * * * *01 * * *03

I am trying to build a statement that says if C = ++++++++ and E = 03
then return VC, if C = ++++++++ and E = 02 then return PC otherwise
return OK

I tried this but I cannot get it to work
=IF(AND(C2="++++++++",E2="03"),"VC",if(C2="+++++++
+",E2="02"),"PC","OK")

Any help will be appreciated!!

=IF(C2="++++++++",IF(E2="03","VC",IF(E2="02","PC", "OK")),"OK")


"Cheekyaardvark" wrote:

Can anybody help me out with a formula....

See below
A B C
D E
04 01 ++++++++ 01 03

I am trying to build a statement that says if C = ++++++++ and E = 03
then return VC, if C = ++++++++ and E = 02 then return PC otherwise
return OK

I tried this but I cannot get it to work
=IF(AND(C2="++++++++",E2="03"),"VC",if(C2="+++++++
+",E2="02"),"PC","OK")

Any help will be appreciated!!

Works great thanks everybody for the help!!

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Cheekyaardvark" wrote in message
...
Works great thanks everybody for the help!!