Formula for validation data


  • Hello, I’m newbie and I need put in validation data a formula for check the next:

    • In column "H". If the column "G" is greater than 0, it must be greater than 0. Otherwise, it must be 0.

    Help me please
    Thank you n Regards.
    Monday, February 25, 2019 3:59 PM

All replies

  • Assuming that the selected range to which you want to apply data validation starts in cell H1, use this formula:


    Regards, Hans Vogelaar (

    Monday, February 25, 2019 4:11 PM