Support Board
Date/Time: Wed, 01 May 2024 21:21:50 +0000
Post From: Spreadsheet
[2019-11-21 17:03:23] |
AndreyPoroshin - Posts: 102 |
Hello, which of the formula operators can be used to solve my problem? X- for example, the average delta curve = MAX (X3: X7) I calculate the maximum delta value for the period from 3 to 7 I need the value 7 in (X7) to be dynamic, and to be substituted from another cell, for example (Y3) - that is, I always know this value. It is calculated in column (Y) As a result, I want to apply this dynamic value, but I don’t know with which operator this can be done correctly? = MAX (X3: X7) = MAX (X3: X (Y3)) simply put, instead of seven you need a value from column Y Date Time Of Last Edit: 2019-11-21 17:05:48
|