When you try to compute the mean absolute percentage error using NumXL MAPE worksheet function, the return value is always 200, regardless of the input data set or options selected.
On our side, we have identified this issue found in NumXL 1.59.41245.1 (Tucson). The problem has been resolved and will be included in the very next NumXL Tucson service pack release (i.e. 1.59).
Thank you for your patience.