1

I have a table for our budget this year; I need to show an estimate budget for next year with a 5% increase all round. Can I do this with a formula as it is going to take hours to do the maths for each cell (approx200 cells!!!)?

1 Answer 1

2

You could use the Array Function feature to apply the calculation to all the source cells in one step.

In the following example, i assume that the source cells are in the cell range A1:C3.

In the first cell of the target range (holding the result of the 5% increase; in my example: A6:C8), insert the following formula and press CTRL+SHIFT+ENTER to enter it (adapt the decimal separator if required):

= A1:C3 + (A1:C3 * 0,05)

enter image description here

Entering a formula using CTRL+SHIFT+ENTER will make LO Calc to interpret it as array function. There are some special point to notice when working with array formulas; the most important thing to remember is that you can edit the result of an array formula only by editing the complete array. So, to edit the formula, you will have to select the complete result array first; and you'll have to finish editing the array formula using CTRL+SHIFT+ENTER.

Anyway, after CTRL+SHIFT+ENTER, the result will look like this:

enter image description here

This way, you can calculate on multiple cells with a single formula.

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .