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