Hello Guru's.
Can anyone suggest me how can i reduce / optimize this two formulas ?
First Formula:
=IF(R$8=$E$6,"End",IF(R$8=$E$5,"Start",IF(R$8=TODAY(),"Today",IF($J9=R$8,$Q9+1,IF($L9=R$8,$Q9+2,IF(AND(R$8>=$J9,R$8<=$L9),$Q9,""))))))
Second Formula:
=IF(COUNTIF(E10:E18,"Late"),"Late",IF(COUNTIF(E10:E18,"At Risk"),"At Risk",IF(COUNTIF(E10:E18,"On Schedule"),"On Schedule",IF(COUNTIF(E10:E18,"Programmed"),"Programmed",IF(COUNTIF(E10:E18,Complete)=COUNTIF(E10:E18,"<>"),"","Complete")))))
Thanks a lot guys, i really appreciate your help and support.
Can anyone suggest me how can i reduce / optimize this two formulas ?
First Formula:
=IF(R$8=$E$6,"End",IF(R$8=$E$5,"Start",IF(R$8=TODAY(),"Today",IF($J9=R$8,$Q9+1,IF($L9=R$8,$Q9+2,IF(AND(R$8>=$J9,R$8<=$L9),$Q9,""))))))
Second Formula:
=IF(COUNTIF(E10:E18,"Late"),"Late",IF(COUNTIF(E10:E18,"At Risk"),"At Risk",IF(COUNTIF(E10:E18,"On Schedule"),"On Schedule",IF(COUNTIF(E10:E18,"Programmed"),"Programmed",IF(COUNTIF(E10:E18,Complete)=COUNTIF(E10:E18,"<>"),"","Complete")))))
Thanks a lot guys, i really appreciate your help and support.