ROUNDDOWN FORMULA

  • Resolved aespada

    (@aespada)


    11 years, 2 months ago

    Hi,

    I have a calculator from excel and I want to implement it to your plugin.

    Formula in excel
    C1 =ROUNDDOWN(SUM(607.5/A1),0)
    D1 =ROUNDDOWN(SUM(407.5/B1),0)
    E3 =SUM(C1*D1)
    F1 =SUM(215/E1)
    G1 =SUM(F1+1)
    H1 =SUM(F1+0.75)
    I1 =SUM(F1+0.5)
    J1 =SUM(F1+0.251)

    Calculated Fields Form
    A1: [fieldname1] = C1: [calculatedfield1]
    B1: [fieldname2] = D1: [calculatedfield2]
    E3: [calculatedfield3]

    F1: [calculatedfield4]
    G1: [calculatedfield5]
    H1: [calculatedfield6]
    I1: [calculatedfield7]
    J1: [calculatedfield8]

    F1 + G1 + H1 + I1 + J1 = [calculatedfield9]

    Thanks!

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

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

    (@codepeople)

    11 years, 2 months ago

    Hi,

    You only need to know that in our plugin the SUM function of Excel, is simply the mathematical operator “+”. So, if you want add fieldname1 and fieldname2, use: fieldname1+fieldname2

    In javascript (and our plugin) the equivalent to the ROUNDDOWN operation is the FLOOR operation. So, the formula: ROUNDDOWN(SUM(607.5/A1),0) would be: FLOOR(607.5/fieldname1)

    With this elements you will be able to create your form, but if you need additional help to implement your form, don’t hesitate in opening a ticket in our support page (http://wordpress.dwbooster.com/support), asking for the custom coding service.

    Best regards.

    Thread Starter aespada

    (@aespada)

    11 years, 2 months ago

    I submitted a ticket. can you check now? Thanks.

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

The topic ‘ROUNDDOWN FORMULA’ is closed to new replies.