| |
17.1.7.=CELL ("parentheses", D2) returns 1 if a cell is formatted to have either positive values or all values displayed with parentheses. |
|
Otherwise, 0 is returned.
|
|
|
17.1.Cell | | 17.1.1. | Cell function | | | | 17.1.2. | =CELL ("address") returns the address of the last changed cell. | | | | 17.1.3. | =CELL("color", B3) tells whether B3 is formatted for color-negative numbers | | | | 17.1.4. | =CELL ("contents",B3) returns the contents of B3. | | | | 17.1.5. | =CELL ("filename") returns the path, filename, and work sheet name of the workbook and worksheet | | | | 17.1.6. | =CELL ("format",D1) returns a number format | | | | 17.1.7. | =CELL ("parentheses", D2) returns 1 if a cell is formatted to have either positive values or all values displayed with parentheses. | | | | 17.1.8. | =CELL("prefix", A1) returns the type of text alignment in a cell. | | | | 17.1.9. | =CELL ("protect",A1) returns 1 if a protection is set to locked | | | | 17.1.10. | =CELL("row", B6) returns the row number of the first cell in the range | | | | 17.1.11. | =CELL("row", Summary) returns the row number of the first cell in the name | | | | 17.1.12. | =CELL("type", A1) returns the type of information in a cell. | | | | 17.1.13. | =CELL("width") returns the width of the last changed cell, rounded to an integer. | | | | 17.1.14. | =CELL("width", A1) returns the width of A1 | | |
|