16
: VBA.
: , , .
1. F [5, 20] 1,5;
a = 12, b = 0,5, .
F :
:
1. . 2 VBA- , VBA.
2. 1 "F".
3. Visual Basic F - F(x, a, b).
Insert Module
.
, MS Visual Basic
F(x,a,b) , (A1)
Test(), 5.
Function Test(i As Integer) As Integer
Test = i + 5
End Function
:
4. F ( F [5;20]):
:
= 5.0, F = 7,50;
x = 20, F = 0,43.
5 :
- x F ( 1 2 );
- F VBA;
- (, F x=5.0).
2. :
:
1. :
: R ,
,
S ,
P .
:
P = 85, S 800 1000 25.
2. (P, S), (S, P), 2, " , ", .
Insert Procedure .
, :
, .
3. ( : ( ), - ).
4. :
- , VBA;
- - .
( )
3. ( InputBox MsgBox).
|
|
:
1. CalcRC ( R ), :
1) P (P = 85, = 10) InputBox:
2) S (S = 1000, = 20) InputBox:
InputBox:
InputBox( , , )