Question

explain the two types of formula in libreoffice calc​

Answer 1

Explanation:

Here are a few examples of LibreOffice Calc formulas:

=A1+10

Displays the contents of cell A1 plus 10.

=A1*16%

Displays 16% of the contents of A1.

=A1 * A2

Displays the result of the multiplication of A1 and A2.

=ROUND(A1;1)

Displays the contents of cell A1 rounded to one decimal place.

=EFFECTIVE(5%;12)

Calculates the effective interest for 5% annual nominal interest with 12 payments a year.

=B8-SUM(B10:B14)

Calculates B8 minus the sum of the cells B10 to B14.

=SUM(B8;SUM(B10:B14))

Calculates the sum of cells B10 to B14 and adds the value to B8