equation with multiple variables and multiple inputs for each variable

[Krista]

I have a simple equation - say (a-b)/c

And I have about 10 inputs for each variable

How can I automatically calculate all possible outcomes in excel?

I feel like this is an array formula issue, but I can't get it t
work.

Thanks so much for having this forum and to those who respond

 

[Frank Kabel]

Hi
and where do you want to store the 1000 different results?. Do you want
to sum them??

 

[Krista]

All in one spreadsheet I assume. I am doing this for someone else a
work too old and lazy to try to figure it out.

I think they are just trying to find trends over time for variou
scenarios.

The answers won't be summed. They will just be sorted

 

[Frank Kabel]

Hi
try the following macro:

Sub many_formulas()
Dim a
Dim b
Dim c
Dim row_index
row_index = 1

For a = 1 To 10
For b = 1 To 10
For c = 1 To 10
Cells(row_index, "A").Value = a
Cells(row_index, "B").Value = b
Cells(row_index, "C").Value = c
Cells(row_index, "D").FormulaR1C1 = _
"=(R[0]C[-3]-R[0]C[-2])/R[0]C[-1]"
row_index = row_index + 1
Next
Next
Next
End Sub