| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find if range = 0 or ""
have items: OR((CR9:CW9)={"",0}), to exclude from a fromula, thanks
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find if range = 0 or ""
if any cell in range = 0 or "" nothing, then "",
"nastech" wrote: have items: OR((CR9:CW9)={"",0}), to exclude from a fromula, thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find if range = 0 or ""
found it, thanks;
=IF(OR(COUNTIF(CR9:CW9,{"",0})),"", "nastech" wrote: have items: OR((CR9:CW9)={"",0}), to exclude from a fromula, thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) | |||
| Search range of cells, find a value, output adjoining cell. How? | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| I need a formula to find rows within a date range in one column? | Excel Worksheet Functions | |||
Hybrid Mode
