Hi All,

I am trying to put together a largish IF Function with multiple IF functions and some nested IF functions.

I have tried to build each one separately but need them all in one cell. So far i have got these:
  • IF(AND(I9>=3,DATEDIF(T4,U9,"d")>=3),"On Track - Blackbook","BlackBook Overdue")
  • IF(AND(T4>=M9,T4<=N9),"Clock Stopped",IF(AND(I9>=0,DATEDIF(T9,V9,"d")>=0),"On Track - Blackbook","BlackBook Overdue"))
  • IF(AND(T4>=R9,T4<=S9),"Public Comment Period",IF(AND(I9>=0,DATEDIF(T9,V9,"d")>=0),"On Track - Blackbook","BlackBook Overdue"))
  • IF(AND(T4>=T9,T4<=V9),"In Blackbook Process",IF(AND(I9>=0,DATEDIF(T9,V9,"d")>=0),"On Track - Blackbook","BlackBook Overdue"))
  • IF(AND(T4>=V9,T4<=W9),"Blackbook Complete in Appeal Period",IF(W9=”N/A”),"Complete","Blackbook Complete in Appeal Period"))
  • IF(AND(T4>=W9,T4<=Y9),"On Track – Appeals Report",IF(T4>=Y9),"Appeals Report Overdue"))

Im not sure of how to put it all together as one formula.

Any help would be greately appreciated

Jake