Special Offer

Purchase OAK5 during the month of July and benefit from our anniversary price of £199.

Buy now
Operis Analysis Kit /
  • Applications
    • Building spreadsheets
    • Interpreting spreadsheets
    • Spreadsheet Review
  • Features
  • Pricing
  • Support
    • Workshops
    • FAQ
    • Documentation
  • Blog
  • About OAK
  • Get in touch
Operis Analysis Kit
  • Applications
    • Building spreadsheets
    • Interpreting spreadsheets
    • Spreadsheet Review
  • Features
  • Pricing
  • Support
    • Workshops
    • FAQ
    • Documentation
  • Blog
  • About OAK
  • Get in touch

Start your free trial

Blog

See OAK elucidate a difficult formula 9 Jun 2009

Share now

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.

[hana-flv-player video='/media/OakPruning/OakPruning.flv' /]


Share now

Categories

  • Discover OAK
  • Modelling Insights
  • OAK Releases

Archive

Companies who decipher complex spreadsheets with OAK

Pricing

Reduce the time and cost associated with interpreting a spreadsheet model using OAK. See what’s included in the price.

See how OAK works in practice

Attend our free monthly webinar to learn how you can use OAK’s tools to help you to build, review and interpret complex spreadsheets.

Support

We’re here to help. Get answers to questions about installation, licensing and new releases.

Everything you need to build, analyze and audit a spreadsheet. And make better decisions

Try OAK for free
OAK
  • Features
  • Pricing
  • About OAK
  • Workshops
  • Support
Legal
  • Privacy Notice
  • Cookie Policy
  • Legal disclaimers
OAK Applications
  • Building spreadsheets
  • Interpreting spreadsheets
  • Spreadsheet Review
Contact us
  • 110 Cannon Street
    London
    EC4N 6EU
  • +44 (0)20 7562 0400
  • [javascript protected email address]

©2022 Operis Analysis Kit. All Rights Reserved.

Powered by FL1 Digital