The formula can be any expression that evaluates to a boolean value of TRUE or FALSE, or returns a numerical value, where a nonzero value is interpreted as TRUE and 0 is interpreted as FALSE.įormulas can use relative referencing.

Only allow values that result in the formula entered in the Formula box to return TRUE, when the formula is calculated with the entered value. Only up to 255 characters are saved, when using Excel format.Įntries whose length corresponds to the condition. Numbers evaluate to their value, so if you enter the number 1 in the list, the entry 100% is also valid. If you specify a range of columns and rows, only the first column is used.Īllow only values or strings specified in a list. The range may consist of one column or one row of cells. The cell range can be specified explicitly, or as a named database range, or as a named range. The entered values are formatted accordingly the next time the dialog is called up.Īllow only values that are given in a cell range. Only whole numbers corresponding to the condition.Īll numbers corresponding to the condition.Īll numbers corresponding to the condition. AllowĬlick a validation option for the selected cell(s). For example, you can define criteria such as: 'Numbers between 1 and 10' or 'Texts that are no more than 20 characters'.

Onlyoffice libreoffice