Hi, I have a form that calculates each item as YES, NO, NA.
From the attached excel, I have 18 items under parameter BS.
How the calculation should works:
If all 18 Items are either YES or NO, it should sum and divide by 18 items.
But Im trying to figure out, if out of 18 items, 8 items are categorized as N/A, then the calculation should be Sum and Divide 10 items. (18 items: 10 items = Yes, 8 = N/A , total = 100%)
Any item categorized as N/A should not be counted.
Could you kindly guide me how I can do that?
Attached File(s)
Audit_calc.zip ( 27.24k )
Number of downloads: 7
Excel Calculation