| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
RSQ(array1, array2)
Does the RSQ(array1, array2) function ignore cells that contain zero?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match cell in array1 with all cells in array2 | Excel Worksheet Functions | |||
| Paste Special in a macro | Excel Worksheet Functions | |||
Hybrid Mode
