=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 =IF(B11="icl pen",IF(F11=4,4*ROUND(K10*0.25*MIN(H11,1.03)+0.0075,2),K10),K10)
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] ods file
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
So closing.