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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
SUMIF with criteria "<>" & "=" 4
can a cell be both input and output? 2
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
when setting a cell to equal a blank cell it displays 0 2
How to get string to use IF formula only when another cell is text 2
Variance Analysis and Excel 1
Function for summing or counting cells based on a specified fill color 2

Back
Top