Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to add to nested IF | Excel Worksheet Functions | |||
nested ifs not enough | Excel Discussion (Misc queries) | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested If | Excel Programming | |||
What is quicker? Nested or non nested ifs | Excel Programming |