Can someone help me with the Excel formula to give the nearest ATM strike with a given underlying price and strike increment?
Additionally, is this more processing intensive than simply creating a label row for my strikes as ATM/ITM and OTM?
=IF(A19<$A$2,"ITM",IF(A19=$A$2,"ATM","OTM"))
Thank you.