MS Excel 2007
1. MS Excel, .
C MS Excel. , , , , .
.
2. , .
,
CTRL+SHIFT+ENTER. . :
=(A3;!$A$9:$D$21;4;)
, , :
((A3;!$A$9:$D$21;2;);()).
7000 ., 500 . :
= 7000 + 500 * ( 10).
:
=7000+500*((A3;!$A$9:$D$21;3;)-10)
, ( ) :
=(C3>7;D3*0,5;0)
3. , :
Excel , low.
, ,
high, : , ( ).
MS Access 2007
1. MS Access , MS Excel.
,
MS Excel 3, A2:C5, , .
MS Access 2007 , MS Access.
, , , . , MS Access , .
. , .
2. , .