Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • XL3RowVisible

    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 is necessary for the formula to change in each cell to get correct results.

    For example if many XL3RowVisible formulae are driven by one cell, you must expand this to have one driving cell per row, as seen below.

    Incorrect usage
    Incorrect: All formulae point to a single cell.
    Correct usage
    Correct: Formulae point to their own driving cell. Driving cells copy down the master cell.

    See Also