| 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…') |
(The example was the wrong way round) |
||
| 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 ) )}} | ||
Revision as of 08:09, 4 November 2010
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 ) )
