Error validating the formula

27-Aug-2020 15:20

A common issue when creating dependent lists is the use of illegitimate characters in named ranges.

You cannot begin named ranges with a number, or use spaces and some other symbols.

For these lists, the item selected in one list will affect what options appear in the next list.

In the example below, we have a list of cities in cell F2.

It controls what can be input into a cell, to ensure its accuracy and consistency. In this blog post we will explore 11 useful examples of what Data validation can do.

E1000= A2-E1000; The following 2 workarounds can be used to resolve the problem I. If E1000 is for Plan Type 1,2 and 3; enable A2 for the same Plan Types), 5. Maybe users are recording a transaction that has occurred.