| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3ColumnVisible"
(Created page with 'Shows and hides the column the formula is in. ==Syntax== {{Code|XL3ColumnVisible( Visible )}} ==Parameters== {| class="wikitable" ! Parameter ! Description |- | {{Code|Visible…') |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 16: | Line 16: | ||
==Examples== | ==Examples== | ||
| − | '' | + | ''Shows the column if the value in cell {{Code|C5}} contains an error.'' |
{{Code|1==XL3ColumnVisible( IsError( C5 ) )}} | {{Code|1==XL3ColumnVisible( IsError( C5 ) )}} | ||
| + | |||
| + | ==Limitations== | ||
| + | |||
| + | Please see the XL3RowVisible [[XL3RowVisible#Limitations|limitations]] section for more details. | ||
==See Also== | ==See Also== | ||
* [[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.
Contents
[hide]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.
