=MIN(1.03,H15)shows 1.03 when H15 is 1.0 and -2
have tried with =min(H15,1.03) and same results
seems to work correctly with on some other lines of same sheet, actually this is part of following formula
I cannot confirm it.
Please attach a document, that shows the error.
Which local do you use?
Which language has the spreadsheet?
What settings do you use in Tools > Options > LibreOffice Calc > Formula, sections Formula syntax and Separators?
Created attachment 66713 [details]
I still cannot see any error.
What cell is wrong?
What value do you see in that cell?
What value do you expect in that cell? Calculate it here, manually, step-by-step.
Sorry, I have now realised a mistake that I made
I was moving a MS Works DB to ODS via csv, and had to interpret the formulae loghand, since I have found no way of copying formulae between these unlike systems
Sorry for any inconvenience caused