Support Board
Date/Time: Fri, 28 Feb 2025 17:18:50 +0000
Post From: Overlaying Pivot Points
| [2021-08-11 00:08:10] |
| Botan626 - Posts: 294 |
|
L3:=MAX(K3:OFFSET(K3,$J$30-2,0))
I'm getting this error: #REF! [ MAX ] MAX(K7:OFFSET(K7,$J$30-2,0)) = #REF! (error)
[ : ] K7:OFFSET(K7,$J$30-2,0) = #REF! (error) [ K7 ] K7 = K7 (reference) [ OFFSET ] OFFSET(K7,$J$30-2,0) = K5 (reference) [ K7 ] K7 = K7 (reference) [ - ] $J$30-2 = -2 (number, integer) [ $J$30 ] J30 = (no value) [ 2 ] 2 = 2 (number, integer) [ 0 ] 0 = 0 (number, integer) Date Time Of Last Edit: 2021-08-11 08:52:53
|