![background image](http://html.mh-extra.com/html/sharp/zaurus-zr-5700/zaurus-zr-5700_operation-manual_371075349.webp)
86
TODAY()
Returns the current date (from the
system clock) as a serial number. If the
cell is formatted with the date/time
format DD-MMM-YY, this serial number
is displayed as the current date.
Example: TODAY() appears as
03-Sep-96 when the date is Septem-
ber 3, 1996 and the cell is formatted
to display the date.
DATE(
year
,
month
,
day
)
Returns a serial number correspond-
ing to the date, where
year
is a 2- or
4-digit integer (e.g. 1996 or 96),
month
is an integer from 1 to 12, and
day
is an integer from 1 to 31.
Example: DATE(1996, 3, 22) displays
22-Mar-96.
DATE(1996, 3, 22)+1 displays 23-Mar-
96.
NOTE
When you enter a year after 2000, be
sure to enter it in four digits.
SUM (
values...
)
Returns the sum of all the
values
in
list of arguments.
Example: SUM (23,293,-97,63)
returns 282. SUM (A1:A4) returns the
sum of
values
in cells A1 to A4.
Date/time functions
All time functions use a 24-hour clock.
The spreadsheets represent date and time information
in cells as “serial numbers.”
Creating date and time representations
There are six functions for creating date and time
representations:
NOW()
Returns current date or time. If the cell
is formatted with the date/time format
HH:MM:SS, this serial number is
displayed as the current time (from the
system clock).
Example: NOW() appears as
09:27:45 when the time is 09:27:45
a.m. and the cell is formatted to
display the time.
Summary of Contents for Zaurus ZR-5700
Page 34: ...34 ...
Page 46: ...46 ...
Page 96: ...96 ...
Page 118: ...118 ...
Page 244: ...244 ...
Page 263: ...viii ...
Page 267: ...4 ...
Page 285: ...22 ...
Page 323: ...60 ...
Page 339: ...76 ...
Page 366: ...103 Communication Applications ...
Page 367: ...104 ...
Page 371: ...108 ...
Page 379: ...116 ...
Page 395: ...132 ...
Page 401: ...144 ...
Page 403: ...146 ...
Page 413: ...156 ...
Page 439: ...182 ...
Page 445: ...188 ...
Page 459: ...202 ...
Page 483: ...226 ...
Page 489: ...232 ...
Page 499: ...242 ...
Page 500: ...243 Terminal Introduction 245 Using Terminal 251 Troubleshooting 258 ...
Page 501: ...244 ...
Page 518: ...261 Index Spreadsheet 263 CompuServe 266 Pager Access 268 AT T Mail 270 Terminal 271 ...
Page 519: ...262 ...
Page 529: ...272 ...