CHAPTER 3:
HancomMobileSheet
37
The formulas are calculated from left
to right and are calculated according to
the order of the operators. However,
data with parentheses have first
priority.
•
Creating Formulas
Formulas can be made to do any of a variety of calculations from simple
arithmetic to high-level mathematical calculations such as log and exponents.
You use them to perform complex calculations that can incorporate up to 183
overlapping functions. Calculation formulas can be created by using the
keyboard, stylus cell copy and move, or reference other sheet cells. It is
preferable to use calculation sheets using cell addresses, rather than inputting
them directly in the cell. When using cell addresses in calculation formula, you
must always start with the equal sign [=]. You can also use the keyboard or
stylus to select the address directly for creating calculation formulas.
①
Input the following data to enter a formula.
② Tap on cell B6 to create a formula calculating the number of shipments, and
enter [=]. When you press the UP arrow key you will see that the cell
addresses are changing in cell B6. Once the C3 cell is selected, press ENTER
and the formula will be created.
Operator Contents
- negative
% percentage
^ exponent
* / multiply, divide
+ - add, subtract
& letter combination
= > < >= <= != comparison
To Next Page
Loading...
Need help?
General
