Hi,
I am trying to input a formula to provide a rolling percentage, but can't seem to figure it out:
I have 12 cells D4:O4 and in the cell I have a number or letter ie:
1= attended
0= did not attend
A= apologies
D= stand in
in cell T4 i would like it to return a percentage. If I place a 1 or 'D' in D4 I want it to return 100%, if I then place a 1 or 'D' in E4 I want it to return 100% and so on all the way to O4. However, if I place a 0 or 'A' in any of the boxes lets say in F4 it will work out the percentage.
Hope this makes sense
Thanks Matt
I am trying to input a formula to provide a rolling percentage, but can't seem to figure it out:
I have 12 cells D4:O4 and in the cell I have a number or letter ie:
1= attended
0= did not attend
A= apologies
D= stand in
in cell T4 i would like it to return a percentage. If I place a 1 or 'D' in D4 I want it to return 100%, if I then place a 1 or 'D' in E4 I want it to return 100% and so on all the way to O4. However, if I place a 0 or 'A' in any of the boxes lets say in F4 it will work out the percentage.
Hope this makes sense
Thanks Matt