I am trying to create a data validation statement for data entry into Cell B1.
Cell A1 has a data validation statement limiting data to a Whole Number between 0 and 9,999,999.
I would like a data validation statement for Cell B1 based on an IF statement.
If A1 is greater than 0 (>0) B1 would...