Using the Calculate tool, you can apply basic mathematical operations, such as addition, multiplication, subtraction, or division, to the entire range in a click. What's more, you can add and subtract percentage or find the percentage of a number - all for multiple cells at once.
Good Day
Hope this message finds you well...
I have this arithmetic Patten that just adds a certain number,I used the =SUM function to get my value which was correct, but to continue with the Patten I need to drag it down to my desired value without reputation of the initial answer.
The patten goes like:
1234
1345
1456 and so on...
to get that I used the difference of each number, which is 111. But now I need excel to automatically add this 111 to the answer I get when dragging down the column to get the Patten straight without reputation .
I hope my explanation is clear, your assistance will be highly appreciated.
Regards
Tshepang
Hi Tshepang,
If I have understood your task correctly, the solution is simple. You don’t even have to use the SUM function.
So,
1. Enter 1234 into A1.
2. 1345 into A2.
3. 1456 into A3.
4. Select the A1:A3 range and you will see the fill handle that is a little square in the lower-right corner of the selection.
5. Click on the fill handle and drag it down. The cells will be automatically filled with the numbers you need:
1234
1345
1456
1567
1678
1789
1900
Hope this will help you!
