2
: Visual Basic for Application.
:
1 , VBA.
.
:
- .
- Excel
- .
- .
- .
- .
VBA: -> Visual Basic Alt + F11
:
( Insert -> Module). .
Insert -> Procedure,
, , ( , , , _) Type Function, OK. .
(), ( 1-, ), ( ) , Excel. Excel.
Function End Function Basic, .. . .
Excel , :
=
. , Excel , -> . . .
Excel f x () ; , Excel .
, .
, 2, 3, 4 ( . 1). .
, Excel .
X Atn (X), π , 4 * Atn(1), tg 45º = tg (π/4)=1, , , , VBA :
() = Atn( / Sqr(- * + 1))
|
|
() = Atn(- / Sqr(- * + 1)) + 2 * Atn(1)
() = Atn() + 2 * Atn(1)
Sqr(X) , Atn() arctg (X)
1 3 , 1. , =0,1, VBA . . 1