Developer(s) | Apple Inc. |
---|---|
Stable release | |
Operating system | macOS |
Type | Spreadsheet |
License | Proprietary |
Website | www.apple.com/mac/numbers |
Developer(s) | Apple Inc. |
---|---|
Stable release | 10.2 / September 22, 2020; 32 days ago[2] |
Operating system | iOS |
Available in | 31 languages |
English, Catalan, Croatian, Czech, Danish, Dutch, Finnish, French, German, Greek, Hindi, Hungarian, Indonesian, Italian, Japanese, Korean, Malay, Norwegian, Polish, Portuguese, Romanian, Russian, Simplified Chinese, Slovak, Spanish, Swedish, Thai, Traditional Chinese, Turkish, Ukrainian, Vietnamese | |
Type | Spreadsheet |
License | Proprietary |
Website | www.apple.com/ios/numbers |
=C2/B2
. As the spreadsheet is unaware of the user's desire for D to be an output column, the user copies that formula into all of the cells in D. However, as the formula refers to data on different rows, it must be modified as it is copied into the cells in D, changing it to refer to the correct row. For instance, the formula in D4 would read =C4/B4
. Excel automates this later task by using a relative referencing system that works as long as the cells retain their location relative to the formula. However, this system requires Excel to track any changes to the layout of the sheet and adjust the formulas, a process that is far from foolproof.[11]average per car = total income / cars sold
. Changes to the layout of the sheet would not affect the formulas; the data remains defined no matter where it is moved. It also meant that formulas calculating intermediate values did not have to be placed in the sheet and normally did not take up room. The downside to Improv's approach is that it demanded more information from the user up-front, and was considered less suitable for 'quick and dirty' calculations or basic list building.[13]= total income / cars sold
. The formula will find the appropriate data and calculate the results independent of the row.[14] Like Improv, this formula does not refer to the physical location of the data in the sheet, so the sheet can be dramatically modified without causing the formula to fail.[14][10-27] | Global Halloween Event Starts on Oct. 27th |
[10-27] | Vault_EU Benefit will come! |
[10-27] | Smelting Recovery on 10/27-11/09 |
[10-27] | Anima Quest on 10/27-11/23 |
[10-26] | Credit Rebate Lottery will Start on Oct. 27th |
[10-22] | Wonderful reward is waiting for Super Returner! |