XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "XL3ColumnVisible"

 
Line 27: Line 27:
 
* [[Formula Reference]]
 
* [[Formula Reference]]
 
* [[XL3RowVisible|XL3RowVisible formula]]
 
* [[XL3RowVisible|XL3RowVisible formula]]
 +
* [[XL3SheetVisible|XL3SheetVisible formula]]
  
 
[[Category:Formulae]]
 
[[Category:Formulae]]
 
[[Category:Report Management Formulae]]
 
[[Category:Report Management Formulae]]
 
[[Category:Report Management]]
 
[[Category:Report Management]]

Latest revision as of 12:50, 29 April 2016

Shows and hides the column the formula is in.

Syntax

XL3ColumnVisible( Visible )

Parameters

Parameter Description
Visible If set to TRUE the column is shown; if set to FALSE the column is hidden

Examples

Shows the column if the value in cell C5 contains an error.

=XL3ColumnVisible( IsError( C5 ) )

Limitations

Please see the XL3RowVisible limitations section for more details.

See Also