Question

Which error is displayed when
text is not recognise in a
formula?
#Value!
#Name!
#N/A
#All of the above​

Answer 1

Answer:

#Value!

The #VALUE! error appears when a value is not an expected or valid type (i.e. date, time, number, text, etc.) This can happen when a cell is left blank, when a text value is given to a function that expects a numeric value, or when dates are evaluated as text by Excel.