Calc Guide

Simple Calculation in 1 Cell Calculation by Reference
Figure 125: A simple calculation
Table 7: Common ways to enter formulas
Formula Description
=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.
Chapter 7 Using Formulas and Functions 181