K
Kaylen
I am trying to make a template with a list of questions. The answers are
scores ranging from 0-4, with an option of N/A (not applicable). The users of
the template will be entering the [Date] that they answer the questions and
the answers to the questions (0-4, or N/A).
Here is when the calculations are involved: I want to average the answers at
a given date (Date=#) for questions 1-5 and sum the answers from questions
6-8, and then average the answers from questions 9-12, etc. But if, for
example, the answers for questions 9-12 are all "N/A", then I want the
average
or sum formulas to show "N/A" instead of error. At the end I want to have a
grand total score, the sum of all the averages and sums above. Because the
questions are so long to be columns headings, I am thinking of
having them as numbers across the table and relabeling them as questions
later in the form. Can you give me any idea how I should create this template
database so others can use to answer questions and run report to see to the
scores of a given date? Many thanks..
scores ranging from 0-4, with an option of N/A (not applicable). The users of
the template will be entering the [Date] that they answer the questions and
the answers to the questions (0-4, or N/A).
Here is when the calculations are involved: I want to average the answers at
a given date (Date=#) for questions 1-5 and sum the answers from questions
6-8, and then average the answers from questions 9-12, etc. But if, for
example, the answers for questions 9-12 are all "N/A", then I want the
average
or sum formulas to show "N/A" instead of error. At the end I want to have a
grand total score, the sum of all the averages and sums above. Because the
questions are so long to be columns headings, I am thinking of
having them as numbers across the table and relabeling them as questions
later in the form. Can you give me any idea how I should create this template
database so others can use to answer questions and run report to see to the
scores of a given date? Many thanks..