I have 10 fields, lets say field1, field2..... field10, each containing a drop down value of 1-10, with an optional blank choice if the particular item is not applicable. In addition, not all fields might be used, the user might only fill out fields 1-5.
What I ultimatly want to achieve, is to calculate a percentage of the fields which have been filled in, So if only 5 fields are filled in, the maximum possibly score would be 50 (which would be 100%), if the total score is 25, then the user has scored
Thats my simple explanation, now thinking about it, could it be done with IF statements;
"(field1 + field2 + field3 ...+field10) div (100 "then some if statments - if field1 = blank -10, if field2 = blank - 10..... if field10 = blank - 10).
Does that make sense?
Any input is hugely appreciated, in simple terms would really be greatful as ive not long been using the software.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.