ExcelBanter - RSQ(array1, array2)

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

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

- - RSQ(array1, array2) (https://www.excelbanter.com/excel-discussion-misc-queries/71980-rsq-array1-array2.html)

patch2323

RSQ(array1, array2)

Does the RSQ(array1, array2) function ignore cells that contain zero?

George

RSQ(array1, array2)

Direct from the help file:
If an array or reference argument contains text, logical values, or
empty cells, those values are ignored;
however, cells with the value zero are included.

So the answer is no :)

George

patch2323 wrote:
Does the RSQ(array1, array2) function ignore cells that contain zero?

All times are GMT +1. The time now is 05:50 AM.