Support Board
Date/Time: Mon, 03 Feb 2025 17:11:00 +0000
Post From: Spreadsheet
| [2019-11-21 17:03:23] |
| AndreyPoroshin - Posts: 105 |
|
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
|