Data Validation based on IF Statement

[FRED_SHEET]

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 be limited to a Whole Number between 0 and 11.

If A1 is blank or equal to zero B1 can be a Whole Number between 0 and 9,999,999.

I am not sure how to write data validation statement for B1 which would accomplish this result.

Any help would be greatly appreciated.

 

[Alex Blakenburg]

I think this is what you are looking for
Min =IF(A1>0,0,0)
Max =IF(A1>0,11,9999999)

 

[FRED_SHEET]

I think this is what you are looking for
Min =IF(A1>0,0,0)
Max =IF(A1>0,11,9999999)

View attachment 35164

Thank you that did the trick! Appreciate your help.

 

[Alex Blakenburg]

No worries. Happy to help.