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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - validate input of cell A1 to either 8 or 0 based on cell B > 0 (https://www.excelbanter.com/excel-worksheet-functions/43152-validate-input-cell-a1-either-8-0-based-cell-b-%3E-0-a.html)

Captnsvo23t

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

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.

David Billigmeier

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

=IF(A10,OR(B1=8,B1=0),B1=0)
--
Regards,
Dave

"Captnsvo23t" wrote:

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.

All times are GMT +1. The time now is 05:35 AM.