Excel's logical functions test whether a statement or data is true or false ... In cell F2, I need to type =AND(B2>18,D2="Gold") because I want Excel to tell me whether the value in B2 is greater ...

and type (alphanumeric, numeric only, true/false, date, etc.). A specific set of values or range of values may also be part of the definition. Technically, a data element is a logical definition ...