Our auditor mentioned the need to validate MS XLS formulas for anything more than basic functions (+-/*)
I was thinking we could have a short validation report with values at various potential extreme use cases and breaking the formula into sections and verifying each output of the formula as we went. Would that work?
I was thinking we could have a short validation report with values at various potential extreme use cases and breaking the formula into sections and verifying each output of the formula as we went. Would that work?