8. Excel 2 .xlsx .
1. . 5 % , , 1000 . , , 5% 0%.
9. , . (3) 1000. _ 3>=1000, __ , , c, 0,05*3, __ - 0 - , . . (IF).
10. .
2. (IF) , . (IF), , ,
1000 . 5%,
, 2000 ., - 10%,
3000 . - 15%.
11. ( IF) , , 3000 . _ : 3>=3000, __ - : 0,15*3.
12. __ : 2000, 1000 1000.
13. (0,15*3, 0,1*3, 0,05*3 0). (IF). __ (IF).
=(B3>=3000;0,15*B3;(B3>=2000;0,1*B3;(B3>=1000;0,05*B3;0)))
, , (IF) .
. ( IF ) : , , . (3000, 2000 1000), , ( IF ).
14. .xlsx .
__________________________
