Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Formula - I\'m trying to pull down bottom Right of cell \"Cross\" to continue fo

ID: 3561626 • Letter: F

Question

Formula - I'm trying to pull down bottom Right of cell "Cross" to continue formula with next cell address - but it chooses the same cell over and ovrer again.

Please help!!! - I cannot seem to make my pull down option (small black cross symbol) in bottom right of cell work.
I have made a simple formula and now I want this to be continued down the column with new cells down - but when I pull down small black cross I only duplicates the cell's formula without adding automatically the new cell address of the one below - sorry very hard to describe... and so easy to do - Hope I'm makinng sense.

Explanation / Answer

It's impossible to tell without seeing the formula, itself, but thee most likely cause is that the formula is not syntactically correct or not preceded by an equals sign (=) so it's being interpreted as a Text String. Exactly what iss the content of the cell -- beginning to end???