Basically I want to lump all strikes together by certain delta ranges and average them. I am trying to do this in the V5:X19 area.
So in cell X6 I would like the formula to say "Average of all strikes widths(column G) in-between -3 and -1.1." and for it to copy down to average all widths with delta between -1.1 and -0.55, -0.55 and -0.25, ect.
Can anyone help?
Aucun commentaire:
Enregistrer un commentaire