| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF FALSE anywhere in range
I want to put an IF function in a conditional format that activates if
anywhere in range AG13:AG53 there is the result FALSE. Any suggestions? -- David P. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF FALSE anywhere in range
Don't need an IF
Say Formula is: =AG13*AG14*AG15*AG16*AG17*AG18*AG19*AG20*AG21*AG22 *AG23*AG24*AG25*AG26*AG27*AG28*AG29*AG30*AG31*AG32 *AG33*AG34*AG35*AG36*AG37*AG38*AG39*AG40*AG41*AG42 *AG43*AG44*AG45*AG46*AG47*AG48*AG49*AG50*AG51*AG52 *AG53=0 because if any value is FALSE the product is zero. -- Gary''s Student - gsnu200793 "David P." wrote: I want to put an IF function in a conditional format that activates if anywhere in range AG13:AG53 there is the result FALSE. Any suggestions? -- David P. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF FALSE anywhere in range
Perhaps
=NOT(AND(AG13:AG53)) "David P." wrote: I want to put an IF function in a conditional format that activates if anywhere in range AG13:AG53 there is the result FALSE. Any suggestions? -- David P. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF FALSE anywhere in range
Another:
=countif(ag13:ag53,false)0 or =if(countif(ag13:ag53,false)0,"at least one false","no falses") David P. wrote: I want to put an IF function in a conditional format that activates if anywhere in range AG13:AG53 there is the result FALSE. Any suggestions? -- David P. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Percentage of True (or False) in a range | Excel Discussion (Misc queries) | |||
| check for FALSE values in a range of cells in VBA | Excel Discussion (Misc queries) | |||
| Hiding rows in a range based on TRUE/FALSE value in each row | Excel Discussion (Misc queries) | |||
| Return True/False to check duplicate items in a range with one for | Excel Worksheet Functions | |||
| Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE | Excel Discussion (Misc queries) | |||
Linear Mode
