#### 28creation

##### Board Regular

- Joined
- Oct 13, 2014

- Messages
- 124

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.