| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to add 3 column (of YES) to give a total % complete
I am trying to write a formula that will allow me to add a Yes to one cell
(in 3 different columns) cell and then give a % as the answer For example: Cell A1 = Yes Total would be 40% Cell A2 = Yes Combined (A1+A2) Total would be 70% Cell A3 = Yes Combined (A1+A2+A3) Total would be 100% Any and all help is appreciated! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to add 3 column (of YES) to give a total % complete
Hi,
try =IF(AND(a1="YES",a2="YES",a3="YES"),"100%",IF(AND( a1="YES",a2="YES"),"70%",IF(a1="YES","40%",""))) "preyesone" wrote: I am trying to write a formula that will allow me to add a Yes to one cell (in 3 different columns) cell and then give a % as the answer For example: Cell A1 = Yes Total would be 40% Cell A2 = Yes Combined (A1+A2) Total would be 70% Cell A3 = Yes Combined (A1+A2+A3) Total would be 100% Any and all help is appreciated! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to add 3 column (of YES) to give a total % complete
Thank you... Thank you... Thank you!
"Eduardo" wrote: Hi, try =IF(AND(a1="YES",a2="YES",a3="YES"),"100%",IF(AND( a1="YES",a2="YES"),"70%",IF(a1="YES","40%",""))) "preyesone" wrote: I am trying to write a formula that will allow me to add a Yes to one cell (in 3 different columns) cell and then give a % as the answer For example: Cell A1 = Yes Total would be 40% Cell A2 = Yes Combined (A1+A2) Total would be 70% Cell A3 = Yes Combined (A1+A2+A3) Total would be 100% Any and all help is appreciated! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to add 3 column (of YES) to give a total % complete
your welcome
"preyesone" wrote: Thank you... Thank you... Thank you! "Eduardo" wrote: Hi, try =IF(AND(a1="YES",a2="YES",a3="YES"),"100%",IF(AND( a1="YES",a2="YES"),"70%",IF(a1="YES","40%",""))) "preyesone" wrote: I am trying to write a formula that will allow me to add a Yes to one cell (in 3 different columns) cell and then give a % as the answer For example: Cell A1 = Yes Total would be 40% Cell A2 = Yes Combined (A1+A2) Total would be 70% Cell A3 = Yes Combined (A1+A2+A3) Total would be 100% Any and all help is appreciated! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to add 3 column (of YES) to give a total % complete
A little different approach:
=INDEX({0;40;70;100},COUNTIF(D15:F15,"Yes")+1) This assumes your "yeses" go in columns D, E, and F and that you want a 0 if there are none. Good luck Ken Norfolk, Va On Jun 30, 2:37*pm, Eduardo wrote: Hi, try =IF(AND(a1="YES",a2="YES",a3="YES"),"100%",IF(AND( a1="YES",a2="YES"),"70%",*IF(a1="YES","40%",""))) "preyesone" wrote: I am trying to write a formula that will allow me to add a Yes to one cell (in 3 different columns) cell and then give a % as the answer For example: Cell A1 = Yes *Total would be 40% Cell A2 = Yes *Combined (A1+A2) Total would be 70% Cell A3 = Yes *Combined (A1+A2+A3) Total would be 100% Any and all help is appreciated!- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to add 3 column (of YES) to give a total % complete
=(A1="yes")*0.4+((A2="yes")+(A3="yes"))*0.3
"preyesone" wrote: I am trying to write a formula that will allow me to add a Yes to one cell (in 3 different columns) cell and then give a % as the answer For example: Cell A1 = Yes Total would be 40% Cell A2 = Yes Combined (A1+A2) Total would be 70% Cell A3 = Yes Combined (A1+A2+A3) Total would be 100% Any and all help is appreciated! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to add 3 column (of YES) to give a total % complete
This one slightly shorter.
=(A1="yes")*0.4+COUNTIF(A2:A3,"yes")*0.3 "preyesone" wrote: I am trying to write a formula that will allow me to add a Yes to one cell (in 3 different columns) cell and then give a % as the answer For example: Cell A1 = Yes Total would be 40% Cell A2 = Yes Combined (A1+A2) Total would be 70% Cell A3 = Yes Combined (A1+A2+A3) Total would be 100% Any and all help is appreciated! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to add 3 column (of YES) to give a total % complete
Hi,
here are two short approaches Array enter =SUM((A1:A3="yes")*{0.4;0.3;0.3}) to array enter this press Shift+Ctr+Enter or create a range contain 40% 30% and 30%, in the example below B1:B3 =SUMIF(A1:A3,"yes",B1:B3) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "preyesone" wrote: I am trying to write a formula that will allow me to add a Yes to one cell (in 3 different columns) cell and then give a % as the answer For example: Cell A1 = Yes Total would be 40% Cell A2 = Yes Combined (A1+A2) Total would be 70% Cell A3 = Yes Combined (A1+A2+A3) Total would be 100% Any and all help is appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If the total = between 17-20 give it a score of 5, and so on | Excel Discussion (Misc queries) | |||
| want a formula give total quanitity break up frm other sheet | Excel Worksheet Functions | |||
| Variance Total for less than complete year? | Excel Discussion (Misc queries) | |||
| How do I total a column which was created using the MID function? | Excel Worksheet Functions | |||
| calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
Hybrid Mode
