| (-) | / |
| Abs(N) | N |
| Cos(N) | N, N , |
| Sin(N) | ; N , |
| Tan(N) | ; N |
| Atn(N) | N |
| Exp(N) | , N ( () 2,718282) |
| Fix(N) | N. Fix , . N , Fix , N |
| Int(N) | N. Int , . N , Int , N |
Log(N) N
| Rnd(N) | ; . Rnd VBA- Randomize |
| Sgn(N) | : 1, N ; 1, N ; 0, N 0 |
| Sqr(N) | N. VBA , N |
Visual Basic for Application.
Visual Basic
| (-) | / |
| Asc(S) | , S. "", , 65 |
| Chr(N) |
, N, 0 255, . 65, , "" (Chr(13) , Chr(10) )
| Hex(N) |
, N
| |Oct(N) |
, N
| CBool(N) Boolean- N | |
| CByte(E) | Byte( 0 255); , |
| CCur(E) | Currency; E , |
| CDate(E) | Date. E ( ), 1/1/100 12/31/9999, |
| CDbl(E) | Double; E , |
| Cint(E) | Integer; E , |
| CLng(E) | Long; E , |
| CSng(E) | Single; E , |
| CStr(E) | String; E |
| CVar(E) | Variant; E |
|
|
|
Visual Basic for Application.
VBA- , Date
| (-) | / |
| Date | . . VBA |
| Time | Date. . VBA |
Now
| Year(D) | , Date . 100 9999 |
| Month(D) | , Date, . 1 12, |
| Day(D) | , Date . 1 31, |
| Weekday(D) | , Date. 1 7, ; 1 , 2 |
| Hour(D) | , , Date. 0 23, . D , Hour 0 |
| Minute(D) | , Date. 0 59, . D , Minute 0 |
| Second(D) | , Date. 0 59, . D , Second 0 |
