Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get a text/letters to equal to a percentage
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get a text/letters to equal to a percentage
Hi Jose,
If I understand the question correctly you need to count the number of c'c or n's and divide by the sum of the c's and n's and then format the cell with the formula to percentage. Assume that the c' and n's are in cells A1:A50 then like this for percentage of c's =COUNTIF(A1:A50,"c") / (COUNTIF(A1:A50,"c")+COUNTIF(A1:A50,"n")) Like this for percentage of n's =COUNTIF(A1:A50,"n")/(COUNTIF(A1:A50,"c")+COUNTIF(A1:A50,"n")) -- Regards, OssieMac "jose l." wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get a text/letters to equal to a percentage
Hi,
Here is a formula for % compliance assuming your data is in A2:A100 =COUNTIF(A2:A100,"c")/COUNTA(A2:A100) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "jose l." wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get a text/letters to equal to a percentage
Perhaps I should clarify on this "complicated" minor issue. The spreadsheet
has other data in various fields. The data that I need calculated starts from I7 to I11, then I13 to I17, then I19 to I23, then I25 to I29, then I31 to I35. Then the end result field starts from L7 to L11, L13 TO L17, L19 TO L23, L25 TO L29, L31 TO L35. Confused??? "Shane Devenshire" wrote: Hi, Here is a formula for % compliance assuming your data is in A2:A100 =COUNTIF(A2:A100,"c")/COUNTA(A2:A100) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "jose l." wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get a text/letters to equal to a percentage
Confused? Yes! Show us a sample of the data and the desired results.
-- If this helps, please click the Yes button. Cheers, Shane Devenshire "jose l." wrote: Perhaps I should clarify on this "complicated" minor issue. The spreadsheet has other data in various fields. The data that I need calculated starts from I7 to I11, then I13 to I17, then I19 to I23, then I25 to I29, then I31 to I35. Then the end result field starts from L7 to L11, L13 TO L17, L19 TO L23, L25 TO L29, L31 TO L35. Confused??? "Shane Devenshire" wrote: Hi, Here is a formula for % compliance assuming your data is in A2:A100 =COUNTIF(A2:A100,"c")/COUNTA(A2:A100) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "jose l." wrote: 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get a text/letters to equal to a percentage
do you have a direct email that i can send you the spreadsheet that i am
referring to in this thread? "Shane Devenshire" wrote: Confused? Yes! Show us a sample of the data and the desired results. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "jose l." wrote: Perhaps I should clarify on this "complicated" minor issue. The spreadsheet has other data in various fields. The data that I need calculated starts from I7 to I11, then I13 to I17, then I19 to I23, then I25 to I29, then I31 to I35. Then the end result field starts from L7 to L11, L13 TO L17, L19 TO L23, L25 TO L29, L31 TO L35. Confused??? "Shane Devenshire" wrote: Hi, Here is a formula for % compliance assuming your data is in A2:A100 =COUNTIF(A2:A100,"c")/COUNTA(A2:A100) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "jose l." wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding text to equal text | Excel Discussion (Misc queries) | |||
Text to equal "0" | Excel Worksheet Functions | |||
I want a series of letters to equal a dollar amount? | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |