, .
5.3. x = 15, a = 3.75 m = 0.5 ∙ 104 z : .
, :
Sub CommandButton1_Click()
Dim x As Single, a As Single, m As Single
Dim w As Single, z As Single
x = Val(InputBox(" x"))
a = Val(InputBox(" a"))
m = Val(InputBox(" m"))
w = 0.1 * x * a * (1 - m ^ 2)
z = Sin(w / (2 + w))
MsgBox (w): MsgBox (z)
End Sub
Excel, . Range Cells:
Sub CommandButton1_Click()
Dim x As Single, a As Single, m As Single
Dim w As Single, z As Single
a = Worksheets("1").Range("B3")
m = Worksheets("1").Range("B4")
w = 0.1 * x * a * (1 - m ^ 2)
z = Sin(w / (2 + w))
Worksheets("1").Range("B8") = w
Worksheets("1").Cells(2,9) = z
End Sub
, . (For...Next Do...Loop) .
ForNext , , :
For < > = < . . > < . . > Step < >
<1>
<2>
Next
, Sin(x) 0 1 0.1, :
For x = 0 To 1 Step 0.1
y = Sin(x)
MsgBox (y)
Next
, 1, :
i = 1
For x = 0 To 1 Step 0.1
y = Sin(x)
Worksheets(1).Cells(i, 1) = y
i = i+1
Next
Step , .
Do...Loop , , . , . 4 Do...Loop:
1. While , , . . , , .
Do While <> < > Loop | , , |
Do <> Loop While <> | , , , |
2. Until , , . . , , .
|
|
Do Until <> <> Loop | , , |
Do <> Loop Until <> | , , , |
5.3.
z = {1; 4; 7.5; 9; 15}.
: