[Solved] Increase multiplication by column

Discuss the spreadsheet application

[Solved] Increase multiplication by column

Postby almost317 » Fri Apr 24, 2020 6:36 am

I'm looking for a function to increse my multiplyer with each column.

Example:
 Edit:  

C1=B1+A1
D1=B1+A1*2
E1=B1+A1*3

Any help would be greatly appreciated, thank you in advance.
Last edited by almost317 on Fri Apr 24, 2020 1:03 pm, edited 2 times in total.
OpenOffice 4.1.2
Windows 10
almost317
 
Posts: 2
Joined: Fri Apr 24, 2020 6:29 am

Re: Increase multiplication by column

Postby Zizi64 » Fri Apr 24, 2020 7:44 am

Tip1:
Use the cell from the row 2. Then you can insert the multiplier constants into the row 1
C2=B2+A2*$C$1
D2=B2+A2*$D$1
E2=B2+A2*$E$1

Tip2:
Use the function COLUMN() with an offset value to create the multiplier.

C1=B1+A1*(COLUMN()-2)
D1=B1+A1*(COLUMN()-2)
E1=B1+A1*(COLUMN()-2)
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9542
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Increase multiplication by column

Postby almost317 » Fri Apr 24, 2020 1:00 pm

Thank you very much, I don't know why I didn't think of the constants, that worked like a charm.
OpenOffice 4.1.2
Windows 10
almost317
 
Posts: 2
Joined: Fri Apr 24, 2020 6:29 am


Return to Calc

Who is online

Users browsing this forum: Bill, GVS and 22 guests