Shows and hides the row the formula is in.
Syntax
XL3RowVisible( Visible )
Parameters
| Parameter | Description |
| Visible | If set to TRUE the row is shown; if set to FALSE the row is hidden |
Examples
Hides the row if the value in cell A3 is less than or equal to 10000.
=XL3RowVisible( A3 > 10000 )
Limitations
When published to the Web it's necessary for the formula to change in each cell to get the correct results.
For example, if many XL3RowVisible formulas are driven by one cell, you must make this one driving cell per row, as seen below.
Incorrect: All formulas point to a single cell.
Correct: Formulas point to their own driving cell. Driving cells copy down the master cell.
