Question

which error occurs if the formula contains some invalid data ​

Answer 1

Answer:

This chapter teaches you how to deal with some common formula errors in Excel.

##### error

When your cell contains this error code, the column isn't wide enough to display the value.



Answer 2

If the formula contains some invalid data it shows #REF!, #NULL!, or #DIV/0!

• Excel shows an error value (such as #REF!, #NULL!, or #DIV/0!) in the cell containing the formula if it is unable to properly evaluate a worksheet formula or function.
• Cells with error formulae display an error value along with an error options button that may be used to further narrow down the mistake's causes.
• In the upper left corner of error-valued cells in Excel, a tiny green triangle is visible. One of Excel's error checking rules is broken, as seen by the green triangle on the cell's border.
• In the upper left corner of error-valued cells in Excel, a tiny green triangle is visible.
• One of Excel's error checking rules is broken, as seen by the green triangle on the cell's border.
• The hover text, which is displayed while the mouse pointer is over the error choices button, provides information about why the error value is what it is.
• The most typical Excel error values and some typical causes of the errors, as well as some typical fixes, are listed below.

Hence, If the formula contains some invalid data it shows #REF!, #NULL!, or #DIV/0!

#SPJ3