jaeable.blogg.se

Keep them held down, and then press the enter key. With the formula in the formula bar, hold down the SHIFT and CTRL keys on your keyboard.

Type the following formula: (DON'T press the enter key yet.) Click inside the formula bar at the top.Create the same spreadsheet as in the image above.However, you can use an Array Formula instead of using Autofill. To get the rest of the Cost column, you could then use AutoFill. The first one (0.35 * 17) gives an answer of 5.95. The formula to go in the D column in the image above is simple: So we want to multiply the cost of each chocolate bar by how many we've eaten. As an example, take the Chocolate Addiction spreadsheet you constructed in a previous section. What is an Array Formula?Īn array formula is just a formula that works with arrays (groups of values). So an array is a lot of values treated as one group. Likewise, if you had a column full of car names, then all of those car names together would be an array of car names. If you had some exam scores in the A column, then all those scores collectively would be called an array of exam scores. Which begs the question, what is an array? What is an Array?Īn array is a collection of values, rather than a single value. An array formula, as its name suggests, is a formula that you use on arrays.