Custom function to find maximum of two integers Demonstrates a common mistake with assignment operator Simple integer comparison Basic console output ...

There's a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years.

What you suggest sounds like finding the maximum of a real function of a real variable. There are other kinds of function. So probably what you want is something like max / argmax for real functions ...

The most widely used technique for finding the largest or smallest values of a math function turns out to be a fundamentally difficult computational problem.