equation with multiple variables and multiple inputs for each variable

  • Thread starter Thread starter Krista
  • Start date Start date
K

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
 
Hi
and where do you want to store the 1000 different results?. Do you want
to sum them??
 
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
 
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
 
Back
Top