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