Die deutsche Fassung finden Sie hier.

Scenario:
You want to enter a formula into a cell where normally only certain values are allowed, e.g. cells like "Stock Availability:

When you enter a formula in this kind of cell you get this message:

Solution: Disable Data Validation for the cell (or all cells of this type)

  1. While the cell is still selected, Go to Data -> Data Validation -> Data Validation

2. in Data Validation go to Error Alert and uncheck Show error alert after invalid data is entered, 

optionally turn of validation for all cells of this type: still in Data Validation go to Settings and check Apply these changes to all other... , 

3. then click OK and re-enter the formula in the cell.

Further help on Data Validation is provided by Microsoft:

Enter and format data
Apply data validation to cells
- enabling, formating and FAQs
More on data validation - disabling, errors and troubleshooting

Did this answer your question?