| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3RowVisible"
(Created page with 'Shows and hides the row the formula is in. ==Syntax== {{Code|XL3RowVisible( Visible )}} ==Parameters== {| class="wikitable" ! Parameter ! Description |- | {{Code|Visible}} | I…') |
(The example was the wrong way round) |
||
| Line 16: | Line 16: | ||
==Examples== | ==Examples== | ||
| − | ''Hides the row if the value in cell {{Code|A3}} is | + | ''Hides the row if the value in cell {{Code|A3}} is less than or equal to 10000.'' |
{{Code|1==XL3RowVisible( A3 > 10000 )}} | {{Code|1==XL3RowVisible( A3 > 10000 )}} | ||
Revision as of 08:09, 4 November 2010
Shows and hides the row the formula is in.
Contents
[hide]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 )
