Increasing the price in the cells by £1 each only. Need Help.

General questions and answers about FreeOffice 2021 for Windows. Don't post application-specific questions here, but in the appropriate subforum.
Post Reply
PEWPEWWARS
Posts: 1
Joined: Fri Oct 13, 2023 4:19 pm

Increasing the price in the cells by £1 each only. Need Help.

Post by PEWPEWWARS »

How can I add £1 to each of these items all in one go, I cannot remember the formula at all so any help would be greatly appreciated. I just want to be able to drag down the list so it adds just £1 to each item?

Imagehttps://ibb.co/7RPvM0y
Attachments
Screenshot-2023-10-17-120002.png
Mimile
Posts: 11
Joined: Fri Jul 14, 2023 8:36 am

Re: Increasing the price in the cells by £1 each only. Need Help.

Post by Mimile »

Good morning,
If you want to add 1 to the numbers located in B3:B10 for example, you enter 1 in cell C2 for example. You copy this cell. You select the range B3:B10, right click, paste special, transpose, calculate, add to destination.
Sincerely,
Mimile
Attachments
Capture 01.JPG
Capture 01.JPG (21.6 KiB) Viewed 4704 times
Post Reply

Return to “FreeOffice 2021 for Windows (General)”