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…