View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cheekyaardvark Cheekyaardvark is offline
external usenet poster
 
Posts: 10
Default If And statement

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