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 |