Support Board
Date/Time: Thu, 16 Jan 2025 08:59:47 +0000
Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0
| [2017-10-07 07:34:02] |
| User29926 - Posts: 92 |
|
But we need to understand what exactly the function is expected to do in regards to operating on a single cell.
tomgilb has more knowledge of SC spreadsheets then me. His input would be of higher quality than mines. However, I would suggest resetting the targeted cell to a default false/zero Recal($H$3). Or better, allow the user to supply an optional parameter Recal($H$3,"5"). I have 5 different conditions that would make cell $H$3 reset/recalculate. So I assume that the cell will need to allow more then one reset/recal condition to occur or allow another cell the ability to target cell $H$3 for reset/recalculation. Date Time Of Last Edit: 2017-10-07 09:48:31
|