the value error is displayed
Answers
Answered by
2
Answer:
The #VALUE! error appears when a value is not the expected type. This can occur when cells are left blank, when a function that is expecting a number is given a text value, and when dates are evaluated as text by Excel. ... The #VALUE error is a bit tricky because some functions automatically ignore invalid data.
Similar questions