| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting by numbers w/ words in the same cells | Excel Discussion (Misc queries) | |||
| conditional formatting for cells containing words | Excel Discussion (Misc queries) | |||
| cannot get color in cells and words | Setting up and Configuration of Excel | |||
| calculate the number of words in a row whose length is greater than 2 | Excel Worksheet Functions | |||
| Words in Excel Cells | Excel Worksheet Functions | |||
Threaded Mode
