How to fix #NUM! in Excel and Google Sheets
What you see
- #NUM! displayed
- Often with SQRT, LOG, or date math
Common causes
- Square root of a negative number
- Number too large or small for the function
How to fix it
- Check input values are valid for the function
- Wrap calculations to avoid negatives inside SQRT
- Verify date values are real dates