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
|