Hi
please help I need a formula to calculate the average percentage
how it should work is as follows:
there are 6 questions you can insert a 1 or 0 or N/A, if you enter a N/A it should not affect the percentage at all, if all 6 questions are answered N/A the average percentage should be a total of 100%
I can't find a solution please help
thank Megan
Bookmarks