Ask Your Question
0

Transfer calculations [closed]

asked 2017-01-22 15:16:48 +0200

appreciatethehelp gravatar image

Hello all. This is a bit of an odd question but is there any way to transfer calculations made in one row in a spreadsheet to another row?

Here is the relevant document:

C:\fakepath\ECOMMERCE PROVIDER PRICE COMPARISON.ods

I have done the calculations I needed to do on the first row of the table, under the "SHOPIFY" heading. Instead of entering all the same calculations in the other rows with the headings "BIGCOMMERCE", "WIX", "WEEBLY" and "SQUARESPACE", is there any way that I could transfer the calculations made in the "SHOPIFY" row to the other rows? The only thing that would need to change is the row number on each calculation would need to go up a number each time, as I go down to the next row.

Does my question make sense? If not I will try to add more detail.

Thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-01-30 20:33:20.446275

1 Answer

Sort by » oldest newest most voted
3

answered 2017-01-22 17:46:52 +0200

Lupp gravatar image

updated 2017-01-22 17:49:27 +0200

"Does my question make sense?"
I cannot judge as I do not understand what you want to achieve. Concerning the references in your few formulae:

The adaption of row numbers you want is the standard applied to relative row addresses when copying / filling formulae.
Simply fill down the selection B3:V3. The content in H4:J7 created this way will not be what you want. Simply clear this range and enter the values you want.

(Read the Calc Guide about 'Relative and absolute references' in spreadsheets to understand the basic terms.)

The reworked example.

edit flag offensive delete link more

Comments

Sorry for such a basic question- as you said, all I had to do was copy/paste the info from the first row into the other rows to copy the calculation/formula.

Thanks for your time!

appreciatethehelp gravatar imageappreciatethehelp ( 2017-01-30 20:32:54 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2017-01-22 15:16:48 +0200

Seen: 33 times

Last updated: Jan 22 '17