:

9.
  • 7 77.78%
  • 2 22.22%
  • 0 0%
1 9 123 ...
1 10 90

:

  1. #1

    Sat, 26 Jul 2008 01 PM:48:25
    50
    8










    (36)







    5 20 50

    3
    1- ( .........)
    2- ( .............)
    3- 1 2





    http://www.mediafire.com/?zn2mmfjdg3w


    (37)
    (40)
    (46)

    Elhelaly ; Mon, 03 May 2010 11 AM:22:26 :

  2. #2

    Sun, 02 Aug 2009 07 AM:48:25
    28
    18
    0



  3. #3

    Sat, 26 Jul 2008 01 PM:48:25
    50
    8




    1- D
    2- " "
    3- 17
    4-
    -
    -
    -
    -
    -
    -....
    -
    -
    ( )



    A1 = B1 = C1 =
    A2 = "0" B2 = " " " "


    A1 = B1 = C1 =
    A2 = "0" B2 = " " " "


    A1 = B1 = C1 =
    A2 = "0" B2 = " " " "


    A2 = B2 = C2= D2= E2= F2= G2= H2= I2= J2=
    :




  4. #4

    Sat, 19 Jul 2008 11 PM:34:17
    -
    53
    8





  5. #5

    Thu, 30 Jul 2009 12 AM:21:45
    5
    0



  6. #6

    Sat, 26 Jul 2008 01 PM:48:25
    50
    8



    algaid3a


    4
    : 120201
    100000
    120000
    120200
    120201
    1 2 3 4

    A3
    110100
    110200
    120100
    120200
    130100
    130200
    210100
    220100
    230100
    310100
    410100


    120201 CIB
    120202 CIB
    120211 HSBC
    120221 NSGB
    50 500
    C53
    " = SUM (C1:C52) "
    B53

    = IF(AND($C53>-0.001;$C53<0.001);" ";" ")

    0.001
    C503 B503

    = IF(AND(C503>-0.001;C503<0.001);" ";" ")



    VLOOKUP D3

    =VLOOKUP(C3;' '!$A$1:$C$503;2;FALSE)

    J3

    =VLOOKUP(I3;' '!$A$1:$C$53;2;FALSE)

    502 500

    503
    A503 =
    B503 =
    E503 = A503 , B503
    =A503-B503
    C503 D503 =

    =IF(B503=A503;" ";" ")





    1-
    2-
    3-
    4- ( 50 ) (500) ( 500 )
    5-




  7. #7

    Sat, 26 Jul 2008 01 PM:48:25
    50
    8

    Thumbs up






    1- D
    2-
    3-
    4- .
    A3 =
    B3 =
    C3 =
    D3 =
    E3 =
    F3 =
    G3 =
    H3 =
    I3 = =VLOOKUP($A$1;'[ .xls] '!$A$1:$C$503;3;FALSE)

    5- :
    A4= / 003
    B4 = =IF($A$1='[ .xls]'!C3;'[ .xls]'!G3;" ")
    C4 = =IF($A$1='[ .xls]'!C3;'[ .xls]'!H3;" ")
    D4 = =IF($A$1='[ .xls]'!C3;'[ .xls]'!F3;" ")
    E4 = =IF($A$1='[ .xls]'!C3;'[ .xls]'!C3;" ")
    F4 = =IF($A$1='[ .xls]'!C3;'[ .xls]'!E3;" ")
    G4 = =IF($A$1='[ .xls]'!C3;'[ .xls]'!B3;" ")
    H4 = =IF($A$1='[ .xls]'!C3;'[ .xls]'!A3;" ")
    I4 = =H4-G4+I3

    6- A4:H4
    7- + 503
    8- / 502 A503

    9- 504
    10- A504:H504
    11- + 1003
    12- / 502 A1003

    13 500 6503

    14- I4
    15- + 6503

    6504
    A6504 =
    B6504 =
    C6504 =
    D6504 = =$F$1
    E6504 =
    G6504 = =SUM(G$2:$G6503)
    H6504 = =SUM(H$2:$H6503)
    I6504 = =H443-G443+$I$3
    J6504 = =I6504


    A1=
    B1 = =VLOOKUP($A$1;'[ .xls] '!$A$1:$C$503;2;FALSE)
    B1:E1
    F1 =
    G1 = G1:I1
    J1 = =SUM(J3:J6504)
    A2 = =J1
    A2:C2
    D2 =
    G2 = H2
    I2 = /
    K 1 6504

    ( )
    1- B4
    2- D F1
    3- I


    1- F1
    2- A1
    3- A4:K6504
    4- D
    5-



    ( )

  8. #8

    Sat, 26 Jul 2008 01 PM:48:25
    50
    8
    Elhelaly ; Mon, 19 Apr 2010 10 AM:34:07 :

  9. #9

    Tue, 30 Jan 2007 07 AM:20:29
    35
    11
    0


  10. #10

    Tue, 30 Jan 2007 07 AM:20:29
    35
    11
    0



    C3: C1003 C3:C503

    =IF($A$1='[ .xlsx]'!$C$4:$C$1003,'[ .xlsx]'!G4,"")
    2007

: 1 (0 1 )

  1. : 34
    : Thu, 09 Aug 2012, 10 AM:26:13
  2. gergs8666 ENGLISH FORUM
    : 0
    : Wed, 14 Sep 2011, 12 AM:10:35