Oak pruning

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.

OAK can

•	take a formula that uses Excel lookup functions such as COUNTIF, SUMIF, HLOOKUP, VLOOKUP, INDEX, OFFSET and INDIRECT, which are hard to understand and difficult to test

•	work out which cells are actually referenced by the functions

•	restate the formula so that the difficult function is replaced by direct references to the relevant cells only.

In this way the intent and action of the formula is quickly understood.

Here's a two minute film that shows you how.