# Converting Excel formula to LibreOffice

Hello people!

Sorry if this is a totally ridiculous question but I am new to Libre office and i am trying to open a spreadsheet that I have used on my mac and also on a windows pc but cant seem to get the function to work in libre office. I have included the function below if somebody could tell me how to fix it that would be amazing.

=ROUND(IF(O16>0,IF(M16="Y",AW16(1-O16),IF(AW16>R16,R16 + (AW16 - R16)(1-O16),AW16)),AW16),ROUNDING)

Kind regards Noob kev!

edit retag close merge delete

Sort by » oldest newest most voted

I don't know if it will help you (actually I'm not sure at all), but if you go to Tools (in the top-menu) ->Options->LibreOffice Calc->Formula you can change the 'Formula syntax' to Excel. Again ... I have no idea if it will work. Good luck.

more

I guess ROUNDING it's a name range/formula.

and I think you need operators

=ROUND(IF(O16>0 , IF(M16="Y" , AW16 here (1-O16) , IF(AW16>R16 , R16 + (AW16 - R16) here (1-O16) , AW16)) , AW16) , ROUNDING)

more

I was doing something similar for my excel homework and what I understood is that Calc supports the same function list as Excel just the separator is ; not , so change that and I think it will work

more