none
Remain same value with condition RRS feed

  • Question

  • Hi,
    I need a code that cell N17 will remain the same value until the word "YES" is in cell E19 and then cell N17 will update after save?

    Thanks in advance
    Sunday, January 20, 2019 2:13 PM

All replies

  • Update to what?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, January 20, 2019 3:51 PM
  • Hi Hans

    When "YES" appears in cell E19, and save the worksheet, cell N17 will have new value. Thats why I said cell17 will update after save. Hope you can help me to get this code.

    Thanks

    Sunday, January 20, 2019 4:20 PM
  • OK, but what should be the new value?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, January 20, 2019 4:40 PM
  • Hi

    If I am understanding what you are saying, the new value is just a number coming out from a formula in cell N17.

    Thanks

    Sunday, January 20, 2019 5:01 PM
  • You could use

    =IF(E19="YES",your formula,fixed value)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, January 20, 2019 8:29 PM