I had a request that when the result of a particular expression was negative, then it should just display as zero (it was a measure of how far out of compliance the result was - a negative result meant that they were in compliance so zero was appropriate).
So I could do a simple:
if(myExpression > 0, myExpression, 0)
That is OK if the expression is simple, but if the expression is more complex then it becomes unwieldy and long and hence difficult to maintain.
A much more elegant way is to use RangeMax like this:
Very simple, if my expression dips into the negative then the max value in the range becomes 0. Exactly what I want to achieve and much easier to maintain.