Results 1 to 8 of 8
Thread: Excel
Hybrid View
-
12th November 2009 13:45 #1
Excel
, , , .
xcel, , , . , . , , , 50% .
:
http://img4.imageshack.us/img4/804/tablica1b.jpg
, , , , . .
, , .Last edited by lasko; 15th November 2009 at 12:06.
-
15th November 2009 20:41 #2
, , , . . , 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 , , , , .

-
15th November 2009 20:53 #3
-
15th November 2009 21:05 #4
-
15th November 2009 21:44 #5
-
15th November 2009 23:27 #6
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. , , .
-
16th November 2009 11:25 #7
-
16th November 2009 12:22 #8




Reply With Quote

7th May 2023, 16:02 in PC