sinx | cosx | ex | |x| | tgx | arctgx | lnx | Öx | |
VBA | Sin(x) | Cos(x) | Exp(x) | Abs(x) | Tan(x) | Atn(x) | Log(x) | Sqr(x) |
, :
VB :
Sin(2*x) + (Log(x - 1) + Exp(x +3))/((x^4 + 5*x^2 - 3)^(1/3) + (Tan(x^2))^3
:
< > = < >
:
= 2*a + Log(a + 0.5)
.
1. InputBox, . , a = InputBox( ) , , , (. 5.2). .
. 5.2 − InputBox
InputBox String. Val. , 5.25 b :
b = Val(InputBox( b))
. , , 1,2×10-6 1.2-6
2. Excel. , A2, :
x=Worksheets("1").Range("A2")
x=Worksheets("1").Cells(2, 1)
Worksheets("1") Excel 1, Range("A2") 2, Cells(2, 1) 2 1 (. . 2).
.
1. MsgBox. Ÿ , . , MsgBox ( ) c , .
, , ( ). Format(x, ##.##), x , ##.## .
, , . &, :
MsgBox (" x=" & Format(x, "##.#"))
2. Excel. :
|
|
Worksheets("1").Range("A3") = x
A3.
Worksheets("1").Cells(3, 1) = x
c 3 1, . . 3.
z.
, :