ExcelBanter - Find if range = 0 or ""

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Find if range = 0 or "" (https://www.excelbanter.com/excel-discussion-misc-queries/110539-find-if-range-%3D-0-a.html)

nastech

Find if range = 0 or ""

have items: OR((CR9:CW9)={"",0}), to exclude from a fromula, thanks

nastech

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

nastech

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

All times are GMT +1. The time now is 02:22 AM.