Excel Formula Debugging Trick

Be sure to enter formulas in Excel in all lowercase letters. When you press enter, Excel converts all valid portions of the formula to UPPER CASE. For instance, in the case of =sum(jj1:j10), pressing enter causes Excel to return the #NAME error, with =SUM(jj1:J10). Notice that the incorrect JJ1 is still in lower case, while the rest of the formula was capitalized.