Login Page - Create Account

Support Board


Date/Time: Mon, 20 May 2024 00:37:00 +0000



Post From: Spreadsheet - Referencing Previous Rows

[2018-01-26 16:20:04]
gayer2428 - Posts: 75
In a spreadsheet, I want to reference the previous bars (rows) as in :

AND(OR(AA3 > AB3, CH<>0) (AA4 > AB4, CH<>1), ...)

I did try AA3@4, AB3@4; both gave <SYNTAX> errors.

Could someone post the correct syntax? Thanks.