validate input of cell A1 to either 8 or 0 based on cell B > 0

C

Captnsvo23t

Suppose I havea cell A1 and B1. I want to limit the input to cell b1. B!
can be 0, if cell A1 is 0 or blank. If A1 is > than 0 (anywhole number) than
than cell b1 can be 8 or 0.
 
D

David Billigmeier

Go to Data->Validation. In the "Allow" box choose custom and enter in this
formula:

=IF(A1>0,OR(B1=8,B1=0),B1=0)
 
Top