#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.

a formula that produces it

="a"+1

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

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

related