View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cg_tor cg_tor is offline
external usenet poster
 
Posts: 1
Default Nested Ifs VBA, How to

Hello, Would anyone show me how to put the ifs statements below in VBA. I
would like the results to show in column AQ:


IF(AND(U20,V2=0),"ORF "&R2&" to "&W2,

IF(AND(O21,P21),"At "&Q2,

IF(AND(O21,P2=0),"ORF "&L2&" to "&Q2,

IF(AND(O2=0,P2=0),"Awaiting PUD from "&L2,

IF(AND(O21,P21),"At "&Q2,

IF(AND(AG20,AH20),"At "&AI2,

IF(AND(AG20,AH2=0),"ORF "&AD2&" to "&AI2,

IF(AND(AA20,AB20), IF(AND(AA20,AB2=0),"ORF "&X2&" to "&AC2,

IF(AND(U20,V20),"At "&W2,

IF(AND(AM20,AN20),"At "&AO2,

IF(AND(AM20,AN2=0),"ORF "&AJ2&" to "&AO2,"Check"


Thanks in advance