Hi,
I can't figure out how to go about writing a formula for this.
Here's a link to my sample editable spreadsheet in Onedrive:
https://1drv.ms/x/s!AjE7rOJOD5SS0A56EdcLfmKnJeMO
At the top is some sample data collected from students taking a pre and post fitness assessment. If they did both the pre and the post, they receive 25 points. If they did only one, they receive 0 points. I also need to get the average between the pre and post test.
Any help is much appreciated!
Thanks,
Tim
I can't figure out how to go about writing a formula for this.
Here's a link to my sample editable spreadsheet in Onedrive:
https://1drv.ms/x/s!AjE7rOJOD5SS0A56EdcLfmKnJeMO
At the top is some sample data collected from students taking a pre and post fitness assessment. If they did both the pre and the post, they receive 25 points. If they did only one, they receive 0 points. I also need to get the average between the pre and post test.
Any help is much appreciated!
Thanks,
Tim