Coverting Fomula so compatible with calc

asked 2016-01-10 13:34:56 +0200

kevincoates112 gravatar image

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

edit retag flag offensive close merge delete

Comments

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?

Lupp gravatar imageLupp ( 2016-01-11 15:31:28 +0200 )edit