Question

excel will tell you if your formula contains an error?
​

Answer 1

Answer:

> Excel Options > Formulas. Under Error Checking, check Enable background error checking. ... Cells containing formulas that result in an error: A formula does not use the expected syntax, arguments, or data types. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

Explanation:

hope it will help you