This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
IF(OR(B28=0, B1=1),B27,B28)B28 is the resultant cell.B1 is the cell
containing 1(recalculate) or 0(use the cached one)B27 can be replaced by
the formula referencing other things.I believe this shall do. Can be
added as a property in the GPT functions...