28creation
Board Regular
- Joined
- Oct 13, 2014
- Messages
- 124
Hi all,
I'm producing a spreadsheet for work & need a percentage worked out...
I have 12 boxes with drop down options of 1-5, with the percentage box at the bottom working out the result based on a possible total of 60. All 5s = 60, so 100%.
This was straightforward, but I've now had to include N/A so the dropdown reads:
N/A
1
2
3
4
5
What can I do with the percentage box so it tells the user the correct result based on a possible new total, ie for every N/A that's selected it brings the total down by 5.
For example, 6x 5 = 30, 6x N/A, so still 100%.
Any thoughts?
Thanks in advance.
I'm producing a spreadsheet for work & need a percentage worked out...
I have 12 boxes with drop down options of 1-5, with the percentage box at the bottom working out the result based on a possible total of 60. All 5s = 60, so 100%.
This was straightforward, but I've now had to include N/A so the dropdown reads:
N/A
1
2
3
4
5
What can I do with the percentage box so it tells the user the correct result based on a possible new total, ie for every N/A that's selected it brings the total down by 5.
For example, 6x 5 = 30, 6x N/A, so still 100%.
Any thoughts?
Thanks in advance.