how can I calculate cells containing words yes or no
I have 3 cells, containing either yes or no. I want to calculation where sum
of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
One way... =IF(LEN(B5)+LEN(C5)+LEN(D5)=9,B5,"No") -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Brian N" wrote in message I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
For A10, A1, A12:
In cell B10 enter: =IF((A10="yes")*(A11="yes")*(A12="yes"),"yes","no" ) -- Gary''s Student - gsnu200775 "Brian N" wrote: I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
Try this:
=IF(COUNTIF(A1:C1,"Yes")=3,"Yes","No") Assumes your Yes/No values are in cells A1 to C1. Hope this helps. Pete On Mar 24, 11:26*pm, Brian N wrote: I have 3 cells, containing either yes or no. *I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. * |
how can I calculate cells containing words yes or no
One more, if the cells are adjacent eg A1:A3,
=IF(COUNTIF(A1:A3,"Yes")=3,"Yes","No") If not, =IF(AND(A1="Yes",A6="Yes",A13="Yes"),"Yes","No") Regards, Alan. "Brian N" wrote in message ... I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
Another one:
=IF(A1&B1&C1="yesyesyes","yes","no") -- Biff Microsoft Excel MVP "Brian N" wrote in message ... I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
That's really good! Most innovative and surprisingly simple. A prime example
of "That obvious, why didn't I think of that?" Regards, Alan. "T. Valko" wrote in message ... Another one: =IF(A1&B1&C1="yesyesyes","yes","no") -- Biff Microsoft Excel MVP "Brian N" wrote in message ... I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
yet another one:
=IF(COUNITF(A1:A3,"no"),"no","yes") assuming the cells may be only populated with yes and/or no ;-) |
how can I calculate cells containing words yes or no
I'm puzzled, why no array formulas? <g... {=CHOOSE(OR(B5:D5="No")+1,"Yes","No")} -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Brian N" wrote in message I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
"That obvious, why didn't I think of that?"
I find myself saying that quite often! -- Biff Microsoft Excel MVP "Alan" wrote in message ... That's really good! Most innovative and surprisingly simple. A prime example of "That obvious, why didn't I think of that?" Regards, Alan. "T. Valko" wrote in message ... Another one: =IF(A1&B1&C1="yesyesyes","yes","no") -- Biff Microsoft Excel MVP "Brian N" wrote in message ... I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
why no array formulas?
Good question! =IF(AND(A1:C1="yes"),"yes","no") <g -- Biff Microsoft Excel MVP "Jim Cone" wrote in message ... I'm puzzled, why no array formulas? <g... {=CHOOSE(OR(B5:D5="No")+1,"Yes","No")} -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Brian N" wrote in message I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
I feel better now. <g '-- Jim Cone "T. Valko" wrote in message why no array formulas? Good question! =IF(AND(A1:C1="yes"),"yes","no") <g -- Biff Microsoft Excel MVP |
how can I calculate cells containing words yes or no
A little bit shorter...
=IF(LEN(A1&B1&C1)=9,"yes","no") Rick "T. Valko" wrote in message ... Another one: =IF(A1&B1&C1="yesyesyes","yes","no") -- Biff Microsoft Excel MVP "Brian N" wrote in message ... I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
=IF(LEN(A1&B1&C1)=9,"yes","no")
A1 = yes B1 = yes C1 = no<space Don't'cha just hate me! <g -- Biff Microsoft Excel MVP "Rick Rothstein (MVP - VB)" wrote in message ... A little bit shorter... =IF(LEN(A1&B1&C1)=9,"yes","no") Rick "T. Valko" wrote in message ... Another one: =IF(A1&B1&C1="yesyesyes","yes","no") -- Biff Microsoft Excel MVP "Brian N" wrote in message ... I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
Well, if we are assuming stray spaces, then your formula would fail with any
cell containing yes<space. I would think neither of us has to worry, though, as the OP specifically said "I have 3 cells, containing either yes or no" with no mention of trailing space characters.<g Rick "T. Valko" wrote in message ... =IF(LEN(A1&B1&C1)=9,"yes","no") A1 = yes B1 = yes C1 = no<space Don't'cha just hate me! <g -- Biff Microsoft Excel MVP "Rick Rothstein (MVP - VB)" wrote in message ... A little bit shorter... =IF(LEN(A1&B1&C1)=9,"yes","no") Rick "T. Valko" wrote in message ... Another one: =IF(A1&B1&C1="yesyesyes","yes","no") -- Biff Microsoft Excel MVP "Brian N" wrote in message ... I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
Brian, I have 3 columns A is all the yes's B is all the No's and C is the
person's names. I would like to put a formula in columb A & B to count the yes's and no's. Hope i explained that one right :0) thanks for helping "Brian N" wrote: I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
how can I calculate cells containing words yes or no
Hi
=COUNTIF(A:A,"Yes") =COUNTIF(B:B,"No") -- Regards Roger Govier "SSharp" wrote in message ... Brian, I have 3 columns A is all the yes's B is all the No's and C is the person's names. I would like to put a formula in columb A & B to count the yes's and no's. Hope i explained that one right :0) thanks for helping "Brian N" wrote: I have 3 cells, containing either yes or no. I want to calculation where sum of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes) essentially where answers are all yes then the returned sum is Yes and where the 3 cells are either no or less then 3 yes then the answer would be no. |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com