| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatiing based on another cell | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Linear Mode
