Formula for % complete.
Hi. I have a sheet made up with the column below. I am trying to make the percentage complete auto-fill based on which boxes are checked. I am not sure how I can efficiently do this. I can't figure out how to "add" the check boxes. I am hoping there is a way that I could have 9 options of % Complete.
Pulled+Source Termed+Source QA/QC=75%
Pulled +Source Termed+Source QA/QC+Device/instrument termed=95%
Pulled + Source Termed+Source QA/QC+Device/instrument termed+Device QA/QC=100%
Pulled+Source Termed+Device/instrument termed=90%
Pulled+Source Termed+Device/instrument termed+Device QA/QC=95%
Pulled+Device/instrument termed+Device QA/QC=75%
Help Article Resources
Check out the Formula Handbook template!