Hi,
You have omitted a mathematical operation in the equation, and the number of parentheses is incorrect. The correct structure for the equation would be:
fieldname4*(fieldname9*EXP(fieldname5*fieldname3))
Really, in the previous equation there is a couple of parentheses that are unnecessary:
fieldname4*fieldname9*EXP(fieldname5*fieldname3)
Best regards.
My calculation field is trying to find the square area of a circle but doesn’t seem to be working.
((fieldname2*0.5)EXP2)*3.14159
fieldname2 is the circle diameter X 0.5 = r squared X 3.14159 (pi).
What am I doing wrong?
Hi,
The correct equation in this case would be:
POW(fieldname2*0.5,2)*3.14159
Best regards.
hi, help me please!!! i have this equation
PREC((((fieldname3-fieldname6)*((((((fieldname4/100)/12)+1)(12*5))*((fieldname4/100)/12))/(((((fieldname4/100)/12)*exp(12*5))-1))))+(fieldname11+fieldname12+fieldname13),2))
<backticks>basic the important part is (((fieldname4/100)/12)*exp(12*5))</backticks> this is a calculator of monthly payments
and I dont know why dosent work
Hi,
Please, pay attention to the piece of code:
((((fieldname4 / 100) / 12) + 1)(12 * 5))
You have forgotten the mathematical operator, the correct would be:
((((fieldname4 / 100) / 12) + 1)*(12 * 5))
In reality your code includes many unnecessary parenthesis, the previous code is equivalent to:
(fieldname4 /100/12 + 1)*12 * 5
Furthermore, you should check the value of the “fieldname4” field, because if its value is zero, your equation will include a division by zero, that is an invalid mathematical operation.
Best regards.
Thanks, but I need the results of (fieldname4 /100/12 + 1) be exponent with (12 * 5)
(fieldname4 /100/12 + 1)*exp(12 * 5)
Help me please…
I’m so sorry, your right, I make this big mistake… just a little question, I try to compare the result from a excel sheet, and for example the fieldname4 is for interest (7%), so
(7/100/12+1)*exp(12*5)
in excel appear 1.41762526, and in my form appear 1.7108096088493868e+104, inclusive if I place
PREC(((7/100/12+1)*EXP(12*5)),11)
… I dont understand what I am making wrong… HELP ME!!! please help me!!!
excel sheet
Hi,
I’ve checked the equation in Excel and in the plugin, and the result is the same in both, please, visit the following link:
http://wordpress.dwbooster.com/customdownloads/2016-03-02/screenshot.png
Best regards.
and why the opcion PREC no provide only 11 digits???
Hi,
Please, in this case use the following mathematical operation instead the “PREC”:
ROUND( (7/100/12+1)*EXP(12*5)*100000000000)/100000000000
Best regards.
