# HOw do I get the formula to figure out a percentage?

G

#### Guest

Example
H & P Consent Pre-Sedation
YES NO YES NO YES NO Total Cases
11 13 12 98

I need the percentage of each column.

B

#### BenjieLop

Assuming that your numbers are from A2 to F2, here is a very simpl
solution, i.e., not an elegant formula but will work.

If you want the percentages to appear below the numbers, enter in B2

=if(A2="","",A2/sum(\$A\$2+\$F\$2))

and copy this up to cell F2.

Another option is

=if(A2="",0,A2/sum(\$A\$2:\$F\$2))

Also, don't forget to "percent" format your cells (B2:F2).

B

#### BenjieLop

*_TYPO_CORRECTION_*.

The first suggested formula should be

=if(A2="","",A2/sum(\$A\$2:\$F\$2))

Sorry for this typo ...

B

#### BenjieLop

*MORE CORRECTIONS*:

For the percentages to appear below your raw data (A2:F2), the formul
should be entered in (A3:F3).

In summary, the formula

=if(A2="","",A2/(sum(\$A\$2:\$F\$2))

or

=if(A2="",0,A2/(sum(\$A\$2:\$F\$2))

should be entered in Cell A3 and copied up to cell F3.

Again, sorry for the erroneous previous posts ... it's been a long da
and I will now quit posting until tomorrow.