Formula issue in LibreOffice Calc
imnos
Posted messages
8
Registration date
Status
Member
Last intervention
-
Raymond PENTIER Posted messages 58213 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58213 Registration date Status Contributor Last intervention -
Hello,
I have a physics lab tomorrow, and I wanted to prepare all the formulas in LibreOffice Calc and just enter the parameters when I have the measurements to get my values right away. The problem is that the final formula gave me error: 508. My table looks like this:
The formula is as follows: =(((((A2)²)*SIN(E4)*COS(E4))+(SQRT((((A2)⁴)*((SIN(E4))²)*((COS(E4))²))+(2*9.81*F4*((A2)²)*((COS(E4))²)))))/9.81)
And it starts from this:
I know that error 508 is supposed to mean an imbalance of parentheses, but I've checked everything, and nothing... Does anyone see another problem?
Thank you very much!
Configuration: Linux / Firefox 60.0
I have a physics lab tomorrow, and I wanted to prepare all the formulas in LibreOffice Calc and just enter the parameters when I have the measurements to get my values right away. The problem is that the final formula gave me error: 508. My table looks like this:
The formula is as follows: =(((((A2)²)*SIN(E4)*COS(E4))+(SQRT((((A2)⁴)*((SIN(E4))²)*((COS(E4))²))+(2*9.81*F4*((A2)²)*((COS(E4))²)))))/9.81)
And it starts from this:
I know that error 508 is supposed to mean an imbalance of parentheses, but I've checked everything, and nothing... Does anyone see another problem?
Thank you very much!
Configuration: Linux / Firefox 60.0
2 answers
-
Good evening,
I think there is an error in the writing of the powers:
it should be written as A2^2 and not A2²
Similarly: A2^4 for the power of 4
Advice:
1) you are putting unnecessary parentheses for the powers
2) the formula for calculating d is complex. I would break it down into several parts corresponding to each of the monomials to reduce the risk of error.
