Support Board
Date/Time: Sun, 24 Nov 2024 18:22:57 +0000
Post From: Recreating 2 Spreadsheet cells using Spreadsheet Formula
| [2024-05-21 12:59:41] |
| User656492 - Posts: 143 |
|
I'm trying to use spreadsheet formula studies instead of a spreadsheet to accomplish this: In Cell O3: =if ( E4 > B4, D4 - $H$3, P4- $H$3) In Cell P3: =if ( E4 > B4, D4, O5) This works perfectly, allowing me to follow up the lows of each bar with an offset value in cell $H$3, which = 1.0 Using 2 spreadsheet formula studies, I get zero values instead of the "else" values in the above if's. id9: =if( id0.sg4[-1] > id0.sg1[-1] , id0.sg3[-1] , id10.sg1[-2] ) id10: =if( id0.sg4[-1] > id0.sg1[-1] , id0.sg3[-1] , id9.sg1[-1] -1) This is producing 0 for the else condition of id9.sg1 and -1 for id10.sg1 I'm sure I'm doing something dumb, but can not figure it out. Anybody? Date Time Of Last Edit: 2024-05-21 13:08:57
|