Types of error

Types of error in Calc 

1) #Name? Error (Functional error): This type of error is represent when we write wrong spelling of any formula. 

   #Name? Error

2) ### Error: This type of error is represent when the size of cell is not sufficient to insert multiple values. 

Exp: =now() 

3)# Value ! Error: This type of error is represent when we apply any formula on dissimilar values. 

Exp: 

4) # Div/0! Error (Division error): This type of error represent only on division. 

Exp: 

5) #Err:509-This error appears when we forget to use the separator used in a function.

Exp: =sum(A1b1)= Err:509 

6)#Err:502- This error appears whenever an in valid parameter is inserted into any function.

Exp: sqrt(-16) Err:502