How to fix #VALUE! in Excel and Google Sheets
What you see
- #VALUE! appears
- Formula uses math on cells that look like numbers
Common causes
- Text stored as text instead of numbers
- Wrong argument type in a function
How to fix it
- Check for spaces or currency symbols in number cells
- Use VALUE() to convert text numbers if needed
- Make sure each part of the formula expects the right type