ss wrote:

I have this formula
=(K10+L10-O10)*$P$77
the answer is 0.758

I want to use rounddown (I think) so that the answer is 0.75

I tried formatting the cell to 2 x decimal points but that takes it to 0.76

I think you just want =ROUNDDOWN((K10+L10-O10)*$P$77, 2)

works in LibreOffice anyway and seems to be as defined for excel