Forum Discussion

Aaron Lockett's avatar
Aaron Lockett
Brass Contributor
Apr 24, 2018
Solved

Nested IF

Hopefully someone can understand what I'm trying to achieve and lend a helping hand!   The formula I'm trying to use is as follows: =IF(K2="",D,IF( (L2="Expired"),IF(O5="" AND L2=""),"In Progress"...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 24, 2018
    =IF(O2<>"", "Closed", IF(OR(L2="Expired",ISBLANK(L2)),"In Progress","Closed"))
Aaron Lockett's avatar
Aaron Lockett
Brass Contributor
Apr 24, 2018

Hi there,

 

You have missed the fact that if Column O has a date entered, Column P should display "Closed"

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 24, 2018

Well... you stated that the result would either "Closed" or "In Progress".

And the rules for "In Progress" are: column L is blank or "Expired". So everything else must "Closed".

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Apr 24, 2018

    If I focus on the other statement for "Closed": column L or column O are not blank. This would be:

     

    =IF(COUNTA(L2,O2),"Closed","In Progress")

    Row 5, 6 and 7 show different results. So, your rules are not unambiguously.

     

Resources