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

J

Jen

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.
 
Top