Ask Your Question

Converting Excel formula to LibreOffice

asked 2016-01-09 21:37:31 +0200

kevincoates112 gravatar image

updated 2016-03-11 02:32:27 +0200

Alex Kemp gravatar image

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 flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2016-03-11 03:07:06 +0200

LibreGuy gravatar image

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.

edit flag offensive delete link more

answered 2016-03-11 02:53:33 +0200

m.a.riosv gravatar image

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)

edit flag offensive delete link more

answered 2016-10-26 17:54:01 +0200

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-01-09 21:37:31 +0200

Seen: 3,438 times

Last updated: Oct 26 '16