#VALUE!
An argument or operand has the wrong type.
What it means
The formula asked for arithmetic or a function argument of one type and got another, usually text where a number was expected.
How to fix it
- Convert with VALUE or DATEVALUE before calculating.
- Clean imported text with TRIM and CLEAN.
- Check each argument against the function reference signature.
Common causes
- Arithmetic on text, e.g. ="a"+1.
- A number stored as text, often after an import.
- A function given a range where it expects a single value.
- Date arithmetic against something that is not a date.
A formula that produces it
="a"+1