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 ...

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.

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 ...