Hi all,
I am trying to create a spreadsheet to work out totals/percentages from an audit. I have got the basics done but have hit a snagging point where some of the answers are 'N/A'. If they are N/A then there is obviously no score, if it is not N/A then the max points is 5.
I have 4 columns:
1) points scored for each audit point (N/A or 0-5)
2) total points scored for that section (total depends on how many questions can be answered)
3) max total points available (N/A or 5)
4) the percentage for that section (using 2) / 3) * 100=%).
I need to set a conditional format in the number 3 column (max points available) where as soon as I type a number ranging from 0-5 in the number 1 column, it auto fills to 5 (at the moment I am doing this manually).
If anyone can help you would be earning me MAJOR brownie points with my new management!!
Thank you all in advance.
Matt
