, , , . . - , , Excel. (, ).
Excel , , , . , : = / .
, 5 000 15% . ?
| | | | D |
1 | | | | |
2 | 5000 | 0,15 | =A2*B2 | 5000 0,15 , (750). |
, 29 , 16 – , ?
| | | | D |
1 | | | , | |
2 | 16 | 29 | =A2/B2 | 16 29 ( 0,5517 55,17%). |
( , ), .
, 2390 . 23% 23 . ?
| | | | D |
1 | | 100%-23% ( ) | | |
2 | 2390 | 0,77 | =A2/B2 | 2390 0,77, (3103,90 ). |
, 24 780 , – 25 500 . ? .
| | | | D |
1 | | | , | |
2 | 24780 | 25500 | =(B2-A2)/ABS(A2) | , ABC. 0,02905 ( 2,91%). |
. ABC . , , .
| | |
1 | | |
2 | 97,96 | 1,521% |
3 | | |
4 | =A2*(1-B2) | 97,96 1,521% (96,47). |
5 | =A2*(1+B2) | 97,96 1,521% (99,45). |
, 1,521 % 97,96 . ? , , , ( 2%). ? Excel. , .
, , , Excel – . , , , .