????? ???? ??????? ?????? ?? Excel

???? ???????: 214049 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
?????? ??? ????? Microsoft Excel 97 ?? ??? ???????? ???? 109211
(http://support.microsoft.com/kb/109211/ )
.

?????? ??? ????? Microsoft Excel 98 ?? ??? ???????? ???? 192377
(http://support.microsoft.com/kb/192377/ )
.
????? ???? | ?? ????

??????

???? ??????? ?????? ????? ????? ?? ?? ???? ???? ????? ???? ????? ??? ???? ????? ??? ????????? ?? ???? ??????.

?? ???? ???????? ?????? ??????:
?????? ??? 10 ????? ?? ???????? 0.20 ????? ??? ????. ???? ??????? ???????? ???????? ????? ???? ????? 40 ?????? ???? 0.30 ????? ??? ????.
????? ????? ??????? ?? ?? ?????-???? ?????? ?????? ($0.20+$0.30)/2 = 0, 25 ?????--??? ????? ???? ?????? ????? ??????? ???? ?? ???? ?? ???????? ?? ???? 30 ???? ?? ??????? ???? ??? ?????? ?? $0.30 ?? $0.20 ??. ??????? ?????? ?????? 0.28 ?????? ????? ???? ??? ?? ????? ??????? ?????? ????? ?? ???????? ?? ??? ??????? ?????.

??????? ????

????? ?? ????? ????? ???? ??????? ???????:
  1. ?? ???? ??? ?????? ???? ???????? ???????:
       A1:  Cost     B1:  Cases
   A2:  $.20     B2:  10
   A3:  $.30     B3:  40
  2. ???? ?????? ????? ?? ?? ???? ????? (?? ??? ??????? ??? ??? ?????? ?????):
    =SUMPRODUCT(A2:A3,B2:B3)/SUM(B2:B3)

    ??

    =((A2*B2)+(A3*B3))/SUM(B2:B3)

???????

???? ???????: 214049 - ????? ??? ??????: 28/????? ??????/1434 - ??????: 6.0
????? ???
  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007
  • Microsoft Excel 2010
????? ??????: 
kbformula kbhowto kbinfo kbmt KB214049 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????214049
(http://support.microsoft.com/kb/214049/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????