Answer the question
In order to leave comments, you need to log in
How to force to count on a cycle changing 3 parameters?
In general, I will explain with a simple example.
There is a formula a=10+b*c*d
I have b values varying from 2 to 8 with step 2
and c values from 4 to 10 with step 2
d - from 10 to 50 step 10
How will the formula count all these values?
i.e. first puts the first value of b and counts all the values c, d, etc.
Answer the question
In order to leave comments, you need to log in
If you use only formulas in cells, then it will probably not work, formulas do not support cycles.
If using a macro, then it's easier:
Dim WB as Workbook
Dim WS as Worksheet
Dim i as Integer
Set WB = Excel.ActiveWorkbook
Set WS = WB.Worksheets("Лист1")
i = 1
For b = 2 To 8 Step 2
For c = 4 To 10 Step 2
For d = 10 To 50 Step 10
' Выводит числа в столбик '
WS.Cells(i, 1).Value = 10 + b * c * d
i = i + 1
Next d
Next c
Next b
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question