When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

Convert the cell to text values if it contains a number or formula and you want to make only part of the cell subscript. If you want the entire cell to be subscript, leave it as is. To convert a ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical functions in Excel that enable you to apply Boolean logic are AND, OR, XOR ...