Question

what are the various types of errors produced by the formulas ?
​

Answer 1

Name Error ( #NAME? ) This error arises whenever Excel is not able to recognize the text in the formula. ...

Value Error ( #VALUE! ) ...

Division Error ( #DIV? ...

Null Error ( #NULL! ) ...

Reference Error ( #REF! ) ...

10 Time Saving Excel Shortcuts.