Results 1 to 8 of 8

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    ATI lasko's Avatar
    Join Date: Dec:2007
    Location: Haskovo
    Posts: 161

    Excel

    , , , .
    xcel, , , . , . , , , 50% .
    :
    http://img4.imageshack.us/img4/804/tablica1b.jpg
    , , , , . .





    , , .
    Last edited by lasko; 15th November 2009 at 12:06.

  2. #2
    ATI lasko's Avatar
    Join Date: Dec:2007
    Location: Haskovo
    Posts: 161
    , , , . . , 50% .
    , . , :

    Dim RowB, RowE, Row As Integer
    RowB = 4
    RowE = 23

    Dim WCol, Ncol, RED As Integer
    'pod srednoto
    WCol = 2
    Ncol = 11
    RED = 4

    For Row = RowB To RowE
    If Cells(Row, WCol).Value < Cells(27, WCol).Value Then
    Cells(RED, Ncol).Value = Cells(Row, 1).Value
    RED = RED + 1
    End If
    Next Row

    End Sub

    50%, . 50% , , 50%, 50 .. , IF , 50 , , , , .

  3. #3
    pimpirlit's Avatar
    Join Date: Mar:2004
    Location:
    Posts: 21,712
    0.5?

    (50% )
    !

  4. #4
    ATI lasko's Avatar
    Join Date: Dec:2007
    Location: Haskovo
    Posts: 161
    , 0- 5,

  5. #5
    pimpirlit's Avatar
    Join Date: Mar:2004
    Location:
    Posts: 21,712
    Quote Originally Posted by lasko View Post
    , 0- 5,
    ? , ? ( ) ? 0.5 5 . , .
    Last edited by pimpirlit; 15th November 2009 at 22:04.
    !

  6. #6
    ATI lasko's Avatar
    Join Date: Dec:2007
    Location: Haskovo
    Posts: 161
    If Cells(Row, WCol).Value < Cells(27, WCol).Value Then If Cells(Row, WCol).Value < 50% * Cells(27, WCol).Value Then, If Cells(Row, WCol).Value < 50 Cells(27, WCol).Value Then, .. 50, 0,5 5. , , .

  7. #7
    pimpirlit's Avatar
    Join Date: Mar:2004
    Location:
    Posts: 21,712
    Quote Originally Posted by lasko View Post
    If Cells(Row, WCol).Value < Cells(27, WCol).Value Then If Cells(Row, WCol).Value < 50% * Cells(27, WCol).Value Then, If Cells(Row, WCol).Value < 50 Cells(27, WCol).Value Then, .. 50, 0,5 5. , , .


    If Cells(Row, WCol).Value < 0.5 * Cells(27, WCol).Value Then

    ? ( 0,5 )
    !

  8. #8
    ATI lasko's Avatar
    Join Date: Dec:2007
    Location: Haskovo
    Posts: 161
    , , , 0,5% , , , .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |