by RusselB » Sat Jan 19, 2019 9:45 pm
Are you seeing the formula copied down, rather than the results, or are you seeing the same results?
If you are seeing the formula, go to Tools -> Options -> OpenOffice Calc -> View
Then uncheck the box in the Display section beside Formulas
If you are seeing the same results, check that you don't have $ in front of the row indicator in your formula (ie: make sure it reads C3 not C$3)
If you have eliminated that, then check that the referenced numbers are not the same, or multiply to the same (ie: if A3 has 5 and B3 has a 2, then make sure that A4 isn't 10 with B4 being 1)
There are lots of possibilities that can give you the same results, so the results of the formula look the same, even though the formula is calculating correctly.
If you have eliminated that last option (ie: tested A3 with 5 and B3 with 6, giving C3 at 30, and A4 with 2 and B4 with 3, giving C4 at 6), but your still seeing 30 for C4, then please attach a sample of your document.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.