I am using named ranges to clarify formulas in CALC, but MIN and MAX do not understand the ref when using named ranges including relative refs.
Example:
Named Range: Amount ($B$1:$B$10)
Named Range: Balance ($C$1:$C$10)
Named Range: PrevBalance (=$C2 when selected cell is $C$2) relative ref.
Cell C2: 0
Cell B3: 100,000
Cell C3: =PrevBalance+Amount
Cell E4: =MIN(Balance;500,000) returns 0, should be 100,000.
Cell E4: =MIN(Balance+0;500,000) returns correct 100000.
I think it has to do with when the ref is resolved.`
Any ideas - I do have a short example here: NamedRangeRelativeRefs.ods
[Edit - Opaque] Changed formatting of details for better readability