What does #VALUE! mean?
An input is the wrong kind of thing: letters where a number belongs, or a unit that measures something different.
#VALUE!An input is the wrong kind of thing: letters where a number belongs, or a unit that measures something different.
Type a plain number, like 12 or 3.5.
What’s this?Common causes
- Typing text into a number field
- Linking a length into a voltage input
- A malformed value in a shared link
How to fix it
- Type a plain number, like 12 or 3.5.
- Pick a unit that measures the same kind of thing.
In spreadsheets
Same as #VALUE! in spreadsheets.