| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
conditional formula
I have 3 cells that will return a value of "yes" or "no". In another cell if
any of the other 3 cells has a no I would like it to say "fail", if all 3 are "yes" I'd like it to say "pass". A1 yes B1 no C1 yes E2 fail a1 yes b1 yes c1 yes e2 pass |
|
#2
|
|||
|
|||
|
One way:
E2: =IF(COUNTIF(A1:C1,"yes")=3,"pass","fail") In article , Qaspec wrote: I have 3 cells that will return a value of "yes" or "no". In another cell if any of the other 3 cells has a no I would like it to say "fail", if all 3 are "yes" I'd like it to say "pass". A1 yes B1 no C1 yes E2 fail a1 yes b1 yes c1 yes e2 pass |
|
#3
|
|||
|
|||
|
=IF(AND(A1="yes",B1="yes",C1="yes"),"pass","fail") -----Original Message----- I have 3 cells that will return a value of "yes" or "no". In another cell if any of the other 3 cells has a no I would like it to say "fail", if all 3 are "yes" I'd like it to say "pass". A1 yes B1 no C1 yes E2 fail a1 yes b1 yes c1 yes e2 pass . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
| =IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
| How do I do conditional format based on a cell with a formula? | Excel Worksheet Functions | |||
| Conditional Formula to search ranges?? | Excel Discussion (Misc queries) | |||
Hybrid Mode
