The usage of MAX and MIN functions is pretty common on finance. Until today, we’ve seen a lot of usage of IF ELSE to cover these formulas (e.g. IF variableA > variableB THEN variableA ELSE variableB). However, this makes formulas less readable and clean.

What’s new?

We are now introducing two new functions into our formula library: MAX and MIN to make modeling experience quicker and cleaner.

How do they work?

• MAX formula returns the largest values in a set of variables or constants
• MIN formula returns the lowest values in a set of variables or constants

These functions can also be combined with other functions, such as IF ELSE. 

Learn more about how to use them in the academy:

• MAX: Link
• MIN: Link