### Understanding the Results of an Array Formula

I am trying to mend / understand a workbook an old employee made. I have used the Evaluate Formula feature but am still really struggling to understand the formula. The formula is – =IF(INDEX(Grp2.Customer.Table,Grp2.Cust.Numb,1)IF(Year.Numb=1,Laun.Yr.Start,INDEX(Year,1,Year.Numb-1)),1,0),0) E65 = 1, E66 = 0. But what I am seeing when I am evaluating the formula, suggests to me that…

Details