See OAK elucidate a difficult formula

09 Jun 2009

What does this Excel formula do?

=IF(P1070=”",0, SUMPRODUCT(OFFSET($K1065,0,0,1,MAX(1,MIN($G1059,O$31))), OFFSET(P1070,0,0,1,MAX(1,MIN($G1059,O$31))))*O1044)

No, I haven’t a clue either. But OAK can make sense of it in moments.