Question

write the cause of error occurs in a spreadsheet of #VALUE!​

Answer 1

Answer:

please mark it as the brainliest answer

Explanation:

error. #VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and it can be hard to find the exact cause of it.

Answer 2

Answer:

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.

For example, in the screen below, cell C3 contains the text "NA", and the formula in F2 returns the #VALUE! error.

Excel #VALUE! error example

Below, the MONTH function can't extract a month value from "apple", since "apple" is not a date:

Excel #VALUE! error example with MONTH function

Note: you may also see a #VALUE! error if you create an array formula and forget to enter the formula with Control + Shift + Enter.

please mark me as brainlist