The #DIV/0! error can occur in two situations. #DIV/0!: In division operations, a situation may occur where the program makes an attempt to divide a number by zero (0). You can eliminate this error if you add values in the blank or deleted cell reference(s) mentioned in the formula. #REF: The #REF error occurs when you type in a cell reference that doesn't exist or you deleted without updating the reference. This leads to calculation errors, and the program shows it as a 'value' error. #VALUE: The #VALUE error occurs if you accidentally insert text into cells or formulas that accept or use only numeric data. This is either due to the cell reference may not exist or it may not contain any values to carry out the operation. #NAME: The #NAME error occurs if you enter an invalid cell reference in a formula. For example, =SUM(A1:A10)-MAX(A1:A10) is a valid formula with multiple functions. Write it as TODAY().You can also use multiple functions in the same formula. TODAY: This function returns the current date (for example, 02/17/15). This function does not have any arguments. NOW: This function returns the current time (for example, 03:29:14 PM). For example, COUNT(1,1,4,2,eleven,b) returns 4. COUNT: This function counts the numbers in a list of arguments or a cell range. It takes a numeric value as the argument and an integer as the precedence. ROUND: This function rounds a number to the nearest decimal. Write this function as SQRT(number) or SQRT(address). SQRT: This function returns the square root of a given number. The syntax is similar to the MAX function. MIN: This function returns the minimum value of a given set of numbers or range of cells. Write this function as MAX(n1,n2.n) or MAX(address range).

MAX: This function returns the maximum value of a given set of numbers or range of cells. Write this function as - AVERAGE(n1,n2.n) or AVERAGE(address range). AVERAGE: This function returns the average of a given set of numbers or range of cells.

Openoffice calc graph sheet reference