Coverting Fomula so compatible with calc

[kevincoates112]

hello,

Sorry if I’m being stupid here but I am trying to open my spreadsheet that i use on my mac but for the life of me cannot get to work in libre office. There are 3 calculations that are returning errors in my spreadsheet. If somebody could tell me how to covert these that would be great.

The formulas are:

=ROUND(IF(M85<>“Y”,IF(P85<>“Y”,K85,K85*(AV85-1)),0),ROUNDING)

=ROUND(IF(O85>0,IF(M85=“Y”,AW85*(1-O85),IF(AW85>R85,R85 + (AW85 - R85)*(1-O85),AW85)),AW85),ROUNDING)

=ROUND(IF(N85=“P”,0,IF(OR(M85=“N”,M85=""),S85-R85,S85)),ROUNDING)

Thanks very much
Kev

[Lupp]

No clairvoyants here!
With which application was your sheet created? Which error messages do you get? How did you define the name ROUNDING (it is not a predefined name!)?
Can you provide a relevant example (.ods) demonstrating your issue?