Support Board
Date/Time: Mon, 25 Nov 2024 09:43:35 +0000
Post From: Spread Sheet formulas
| [2024-03-13 21:19:13] |
| User312901 - Posts: 13 |
|
Hi! I'm trying to get some formulas to work. Obviously Sierra Spread Sheet is not working identically with Excel but is it possible to achieve something like this without defining all the rows individually?: =IF(AND(Sheet2!B4:Sheet2!B8 > Sheet2!AF4:Sheet2!AF8), IF(AND(Sheet2!E4:Sheet2!E8 > Sheet2!AF4:Sheet2!AF8), 1, 0), 0) (This is not working) Here I'm trying to return true if two conditions are met. First, values at B column needs to be bigger than values in AF column in all the rows inside the range. Second, values in E column needs to be larger than values in AF column respectively. A further goal would be to be able to determine the last row of the range by referencing to a number in another cell. So basically I would be having a cell where to type in the row number for range length. A lot appreciated if you could help me to crack this one. BR, MikkoS |