LoganTrk

New Member
Joined
Jan 24, 2019
Messages
17
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.
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,219
Select column H and try this DV formula:

=IF(G1>0,(H1>0),(H1=0))

If G1 is empty, anything in H is allowed, but we can add a rule for that too if you want.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,956
Messages
5,525,885
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top