ok..i think this is diffucult, I just dont know cause i have never done this.
but i have a spreadsheet that has two columns one says C/N and the other
percent compliance. the c stands for compliant and the n stands for
noncompliant. basically i want the c & n to equal to a percent in the
percent compliance field, so how do i make the c & n be a "number" and then
equal to a percent???? complicated? confused? there are 5 sections of 5 rows
that have 1 percent compliance field.