R
R
realnin2017-03-20 15:08:47
excel
realnin, 2017-03-20 15:08:47

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

1 answer(s)
A
Anton Fedoryan, 2017-03-20
@realnin

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

If you need numbers without repetitions, then it makes sense to use an array.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question