Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 03:51:55 +0000



Post From: #CREF! error

[2017-10-12 17:10:34]
User29926 - Posts: 92
No update. We do not know when it will be.

It is not something we can get too quickly.

So, what is your working suggesting for a hack/workaround to maintaining a value in a cell until more then one condition could change its value?

Locking and unlocking a cell, that allows more then one condition to unlock it.
Is confirmed not to be possible.
V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0

Allowing a cell to recalculate itself or recalculate another cell is not available.
Spreadsheet recalulate

Trying to maintain a persistent cell value until one of multiple conditions changes it,requiring a cell reference of itself currently does not work either(this support request itself).

I`m all out of ideas of possible hacks/workarounds to get this development completed.