Excel Error fix
#NUM! Error in Excel and Google Sheets: Causes and Fixes
#NUM! means a function cannot produce a valid number. Tested: reversed DATEDIF, SQRT(-1), LOG(0), POWER overflow, backwards RANDBETWEEN, bad YEARFRAC basis.
#formulas
7 tutorials tagged “formulas”.
Excel Error fix
#DIV/0! Error in Excel and Google Sheets: Causes and Fixes
#DIV/0! appears when a formula divides by zero, a blank, or a text zero. Test 1/0, 0/0, MOD, and when IF is safer than IFERROR.
Excel Error fix
#NAME? Error in Excel and Google Sheets: Causes and Fixes
#NAME? means the spreadsheet does not recognize a function or name. Check a typo, unquoted text, a missing named range, or a function that does not exist here.
Excel How-to
Conditional Formatting Based on Another Cell in Excel
Format a cell or an entire row from the value in a different cell, including a threshold in $F$1, a text match, and a date comparison. Includes tested formulas and the Google Sheets steps.
Excel How-to
Conditional Formatting Formula Not Working in Excel
Fix an Excel or Google Sheets conditional formatting formula that does not highlight anything, highlights the wrong rows, or is rejected. Check the applied range, relative references, and the leading equals sign.
Excel How-to
Conditional Formatting in Excel: Formulas, Color Scales, and Highlighting Rows
Apply conditional formatting in Excel with a formula, highlight an entire row, and use color scales. Includes tested rules such as =$B2>=1000 and a Google Sheets menu equivalent.
Excel How-to
Excel Data Validation with a Custom Formula
Use a custom formula in Excel or Google Sheets data validation to allow only numbers in a range, block duplicates, or require a value from a list, with tested TRUE/FALSE checks.