Calculation

  • Resolved FZietsman

    (@fzietsman)


    10 years ago

    I have a hard time solving a calculation with testing options.

    The excel formula looks like this | =SUM(B4*C4)/((B4+C4)*(D4*E4*1.8)+10%) |, and I know that B4, C4 etc should be replaced with fieldname#, but I can’t get this calculation to work at all.

    I have tried various combinations like: (fieldname3*fieldname4)/(fieldname3+fieldname4)*(fieldname5*fieldname6)*(1.8)+(10*(1-10/100)) for instance. No luck

    Can you please assist? I either get no result at all, or a default of 9 square meter with blank fields

    https://ww.wp.xz.cn/plugins/calculated-fields-form/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author codepeople

    (@codepeople)

    10 years ago

    Hi,

    I’m sorry but the Excel formula has not much sense:

    =SUM(B4*C4)/((B4+C4)*(D4*E4*1.8)+10%)

    The operation “SUM” is not necessary in SUM(B4*C4), the section +10% is the same than +0.1, and there are some extra parenthesis.

    So, the previous formula is the same than:

    =B4*C4/((B4+C4)*D4*E4*1.8+0.1)

    If the correspondence of the fields is:

    B4 = fieldname3
    C4 = fieldname4
    D4 = fieldname5
    E4 = fieldname6

    The final equation in the form would be:

    fieldname3*fieldname4/((fieldname3+fieldname4)*fieldname5*fieldname6*1.8+0.1)

    Best regards.

    Thread Starter FZietsman

    (@fzietsman)

    10 years ago

    Wow, Super Fast Response

    Thank you so much, it worked perfectly, you were right with:

    B4 = fieldname3
    C4 = fieldname4
    D4 = fieldname5
    E4 = fieldname6

    I only had to add the “ROUND” function to the equation as it gave me an enormous result of 2.777775658 – with the ROUND function though it rounded it to 3 square meters which is good.

    Appreciate the great support.

    Kind Regards
    Francois

    Plugin Author codepeople

    (@codepeople)

    10 years ago

    Hi,

    If you want a more accurate result, for example with two or three decimal places, use the operation “PREC”

    PREC(X, Y) returns the X number rounded with Y decimal places.

    For example:

    PREC(2.34526, 2) = 2.35
    PREC(2.34526, 3) = 2.345

    Best regards.

    Thread Starter FZietsman

    (@fzietsman)

    10 years ago

    Hi

    Thanks so much – I will give it a try, it will be better with more precise decimal places as it would be great if it rounds it to 2.8 instead.

    Kind Regards

    Francois

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Calculation’ is closed to new replies.