I really hope you guys can help me with this. I've been trying all day!
I want a formula that finds the moneyness closest to 100 for a certain date. I made this formula:
=(IF("02-01-2009"=C2:C131104;INDEX($K$2:$K$131104;MATCH(MIN(ABS(K2:K131104-100));ABS(K2:K131104-100);0));""))
But it searches the entire sheet instead of only the rows where the date is 02-01-2009.
Aucun commentaire:
Enregistrer un commentaire