Support Board

Date/Time: Fri, 03 May 2024 21:25:10 +0000

Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0

[2017-10-07 07:34:02] Link To Thread - Link To Post [Go To First Post]
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