LO formulae should be pretty much identical to Excel, so if you know what you are looking for, it shouldn't be too hard to Google. For example, "Excel copy formula keep one cell constant" (Google actually suggests this halfway through) should get you plenty of hits on syntax you are looking for.