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!
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)
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.
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