|I am trying to create a formula to represent OTD (%) on the following values:|
M5 = Date Returned (Actual)
L5 = Promised Return Date
S5 = Variance (in Days)
If the Date Returned (Actual) equals the Promised Return Date then OTD is 100% but if the Date Returned is greater than the Promise Return Date by 1 day then 10% is subtracted per each day late. I've created the following formula using only the Variance but if I format the column with percentages excel is multiplying each cell by 100 and I am curious to see what the formula would look like using M5 and L5.