I propose that we add a formula to Calc that returns the value only if it's positive. I've seen plenty of spreadsheets where the value of a calculation is only useful if it's positive, otherwise it's considered to be zero. Currently, one must use IF() functions and repeat the value being tested. I imagine that it would look something like this:
Function IfPositive(value, Optional default)
If value > 0 Then
IfPositive = value
ElseIf IsMissing(default) Then
IfPositive = 0
IfPositive = default
And similarly, an IfNegative() function for anyone who may need it. A function like this would really help to simplify these types of formulas. One example is when calculating tax credits:
=IF(273 - IF(C1 - C2 > 0, C1 - C2, 0) * 0.04) > 0, 273 - IF(C1 - C2 > 0, C1 - C2, 0) * 0.04), 0)
Would simplify to:
=IFPOSITIVE(273.00 - IFPOSITIVE(C1 - C2) * 0.04)
I'm not totally sure if IfPositive()/IfNegative() is the best name for this type of function, so any comments on that would also be appreciated.
Just realized this is the same thing as the MAX() formula.