Calculate Implied Volatility in Excel - Invest Excel Learn more about Implied Volatility, its relationship with Vega, and download an Excel ... I modified it so that it can be used on the Black formula of a cap.