none
Formula for validation data

    Question

  • 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:

    =OR(AND(G1>0,H1>0),AND(G1<=0,H1=0))


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

    Monday, February 25, 2019 4:11 PM