How To Repeat Formulas Diagonally?

asked 2019-11-07 06:27:56 +0100

abrogard gravatar image

updated 2019-11-07 08:15:38 +0100

robleyd gravatar image

I have three different formulas in adjoining cells in a row: =f1*0.7 =f1*.2 = f1*0.08

say they're in f5,f6,f7 then I'd want them repeated in the row below, offset one cell to the right..

so that next row should read

=f2*o.7 =f2*0.2 =f2*.08 with the "f2*0.7" directly underneath the "=f1*0.2"

So the whole thing repeats diagonally down the sheet to the bottom right of the working area.

I can't find how I can do this nice and easily. Is there a way?

edit: I don't know what's going on but the editor keeps leaving out the asterisks I put in there in the formulas - seemingly at random. Hope you all can figure out what I mean..

edit retag flag offensive close merge delete

Comments

1

edit: I don't know what's going on but the editor keeps leaving out the asterisks I put in there in the formulas - seemingly at random. Hope you all can figure out what I mean..

Asterisks are used in pairs to markup text for italics start/end. If it cannot be paired, it shows as an asterisk.

Using the "preformatted text" markup (the 101-010 icon) should override this.

keme gravatar imagekeme ( 2019-11-07 08:07:46 +0100 )edit

say they're in f5,f6,f7 then I'd want them repeated in the row below, offset one cell to the right..

Do you mean that the three cells (F5, F6, F7) being in the same column F, should be repeated in G8, G9, G10? Or should F5 be repeated in G6 - next to F6; F6 repeated in G7, and so on? Anyway, it's impossible to shift the group in F to the right, and have the result be "directly underneath the =f1*0.2"

Mike Kaganski gravatar imageMike Kaganski ( 2019-11-07 08:33:40 +0100 )edit

No, I mean Row 1 - a, b, c should be repeated in Row 2 at b,c,d That's what I mean by having one formula 'directly underneath...' What's the best way to show examples of what we mean?

abrogard gravatar imageabrogard ( 2019-11-07 08:45:44 +0100 )edit

The best is to add a sample spreadsheet.

Mike Kaganski gravatar imageMike Kaganski ( 2019-11-07 08:54:11 +0100 )edit

i don't see where we can add files... there only seems to be that preformatted text thing...

abrogard gravatar imageabrogard ( 2019-11-07 11:10:15 +0100 )edit

Edit your question; a clip icon there is for attachments.

Or you may upload a file to an online share, and post a link here.

Mike Kaganski gravatar imageMike Kaganski ( 2019-11-07 11:14:37 +0100 )edit