are the variations constant, or could they be calculated on the fly (is z always 0,497 of x eg) , if stock I would be looking at LOOKUP as an array, or using VLOOKUP against a set of fixed values
A much better explanation than your first offering which didn't give me anything to think about
what is the calculation between D7 to achieve F33
knowing the calculation would help
whoever constructs the formula, needs to understand the interplay between your variables, so starting at 12 what makes 17.454 your final value ?
Sub test()
Dim X as Double
Dim myCell as Range
With Sheets("Sheet1")
Set myCell = .Range("C36")
For X = 15 To 3 Step -.025
myCell.Value = x
.Range("D7").Value = x
Calculate
myCell.Offset(0,1).Value = .Range("F33").Value
Set MyCell = myCell.Offset(1, 0)
Next X
End With
End Sub