Talk:Spreadsheet Tricks

From TeleCafeWiki
Revision as of 21:34, 12 December 2015 by Dave (talk | contribs) (Start talk page -- add table template for spreadsheet formula examples.)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Table Formats

A B C D E
1 Header 1 Header 2 Header 3 Header 4 Header 5
2 1 77 4 7 10
3 2 12 5 8 11
4 3 24 6 9 12
5 Formula Example:

Array Formula: The formulas shown above are array formulas. After typing an array formula into the formula bar, finish by pressing CTRL+Shift+Enter (PC) or CMND+Shift+Enter (Mac).
Please Note: The formula bar indicates that this is an array formula by enclosing it in curly braces { }. Do not type these yourself. They disappear whenever you edit the formula, making it necessary to press CTRL+Shift+Enter (PC) or CMND+Shift+Enter (Mac) whenever you edit the formula. The curly braces { } in the examples shown above are displayed only to show what the formula looks like as it appears in the formula bar.
Source: text and,numbers in same cell, sum of numbers ?

Retrieved from "https://www.telecafe.org/smw/index.php?title=Talk:Spreadsheet_Tricks&oldid=774"