Home Learn about OAK Try OAK Buy OAK Workshops Support OPERIS

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. Here's a two minute film that shows you how.

 

The Camtasia Studio video content presented here requires a more recent version of the Adobe Flash Player. If you are you using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Flash Player by downloading here.