Forum Discussion
Excel Formula
I need a formula in cell M2 to update that same cell ONLY if the current value is NO. Right now, there are 2 possible values for M2 - YES and NO. If the value is YES, I don't want the formula to exec...
This is a circular referencing issue. I do not think there is a solution for this as this value is coming from the cell itself. You can write a formula to evaluate the "YES" situation in the cell however. Like IF(some condition;"YES";another condition)
İf the user would select the "YES" option than this is not possible due the cell content will also be changed. When the user changes the selection the old contents will be overwritten.
You can try to check the "Enable iterative calculation" check box in File-->Options-->Formula however even this can not do much as the cell value is dependent to user selection.