How to Calculate Convexity in Excel To calculate convexity in Excel, begin by designating a different pair of cells for each of the variables identified in the formula.