Multiple Functions In One Column
Thanks again and for the recommendation.
"Pete" wrote:
Try this out in B2 (all one formula, as before):
=IF(V2="","Open",
IF(AND(AD2<"",AE2<""),"Cancelled",
IF(AND(AC2<"",AE2<""),"Closed/BER",
IF(AE2<"",
IF(K2="N/A","Closed/NA",
IF(J2K2,"Closed/No","Closed/Yes")),
IF(K2="N/A","Completed/NA",
IF(J2K2,"Completed/No","Completed/Yes"))))))
It might be better to insert a new column C (assuming you are using C
at the moment), then you can split this formula so that the words
"Open", "Cancelled", "Closed" and "Completed" appear in column B as
appropriate and the words "BER", "NA", "No" and "Yes" appear in column
C (right aligned).
Pete
|