CHAPTER 3:
HancomMobileSheet
33
ꋯ
Text Prefix
Prefix Result Input Result
' Left 'Text Text
" Right "Text Text
^ Center ^Text Text
•
Entering Calculating formulas
Formulas are calculations using the cell data and are input similar to general
math calculations. To input a formula in HancomMobileSheet, you must start
with the equal sign[=]. There are two ways to write formulas. One is to directly
input the data, such as '3+4', into the cell. The other is to use the cell
number, such as 'A1+B1'. When the value of the cell number is changed, the
result value also changes automatically. This reduces time and effort.
•
Entering Numbers into formulas
In entering numbers into calculating formulas, numbers 0~9 can be used.
Commas, parentheses and currency symbols cannot be used together with
numbers in a calculation formula. Negative numbers are indicated with a [-] in
front of the number.
•
Entering Letters into formulas
For entering letters into calculating formulas, input the quotation mark["]. For
example if you input ="year 2000" then the letters 'year 2000' can be used
together with the formula sign [=]. Letters used in functions can also be used
with quotation marks in a formula.
•
Entering Dates
If the date or time is input according to the formats that are designated in
HancomMobileSheet, they will always follow one of those formats. Dates use
the slash [/] or dash [-]. For example, August 1, 2000 could be done as
08/01/2000.
•
Entering Time
You can either use a 12 or 24-hour format for inputting time. A time value is
distinguished by virtue of the colon [:] in the data. For using a 12 hour clock
To Next Page
Loading...
Need help?
General
