IF Formula into Total

  • Resolved jvmartincobos

    (@jvmartincobos)


    2 years, 10 months ago

    Hi! I´m trying to add a IF formula into the total. I have seen a video of the YouTube Channel about this topic (it talks to use a javascript formula to use if formula). I used this formula but don´t works. Any idea?

    Thanks in advance.
    Best,

    function calculateValue(range_field_id_0){if(range_field_id_0<1){return 4.99range_field_id_0;}else if(range_field_id_0<5){return 2.20range_field_id_0;}else if(range_field_id_0<10){return 1.50range_field_id_0;}else if(range_field_id_0<25){return 0.84range_field_id_0;}else if(range_field_id_0<50){return 0.64range_field_id_0;}else if(range_field_id_0<100){return 0.50range_field_id_0;}else if(range_field_id_0<200){return 0.41range_field_id_0;}else if(range_field_id_0<400){return 0.29range_field_id_0;}else if(range_field_id_0<800){return 0.23range_field_id_0;}else if(range_field_id_0<1500){return 0.18range_field_id_0;}else if(range_field_id_0<2000){return 0.15range_field_id_0;}else if(range_field_id_0<2500){return 0.13range_field_id_0;}else if(range_field_id_0<3000){return 0.12range_field_id_0;}else if(range_field_id_0<3500){return 0.11range_field_id_0;}else if(range_field_id_0<5000){return 0.10*range_field_id_0;}else{return “Contacta con ventas”;}}

Viewing 1 replies (of 1 total)
  • Plugin Support juliastylemixthemes

    (@juliastylemixthemes)

    2 years, 10 months ago

    Hello @jvmartincobos ,

    Thank you for the request and sorry for the delay in reply.

    To create a formula with the if/else statements, I would like to offer you our instruction on how to work with the if / else statements at the link: https://docs.stylemixthemes.com/cost-calculator-builder/calculator-elements/total#if-else-statement .

    Also below you can find an example formula:

    if(range_field_id_0<1){4.99*range_field_id_0}else if(range_field_id_0<5){2.20*range_field_id_0}else if(range_field_id_0<10){1.50*range_field_id_0}else if(range_field_id_0<25){0.84*range_field_id_0}else if(range_field_id_0<50){0.64*range_field_id_0}else if(range_field_id_0<100){0.50*range_field_id_0}else if(range_field_id_0<200){0.41*range_field_id_0}else if(range_field_id_0<400){0.29*range_field_id_0}else if(range_field_id_0<800){0.23*range_field_id_0}else if(range_field_id_0<1500){0.18*range_field_id_0}else if(range_field_id_0<2000){0.15*range_field_id_0}else if(range_field_id_0<2500){0.13*range_field_id_0}else if(range_field_id_0<3000){0.12*range_field_id_0}else if(range_field_id_0<3500){0.11*range_field_id_0}else if(range_field_id_0<5000){0.10*range_field_id_0}

    Additionally, I found that you are using text at the end of the formula. Unfortunately, the plugin does not accept text in a formula. You can only use numeric values.

    However, we are always here to improve our product with new features and options, if you think that settings will be useful for most of the Cost Calculator plugin users, we highly recommend you leave your idea in our feature requests desk, our managers will collect and include changes in the future updates according to the popularity of requests https://stylemixthemes.cnflx.io/boards/cost-calculator-builder

    As an option, I want to suggest you using the Condition option to display the text. The instruction on how to work with Conditions is available here: https://docs.stylemixthemes.com/cost-calculator-builder/conditional-system/introduction

    Best regards,

Viewing 1 replies (of 1 total)

The topic ‘IF Formula into Total’ is closed to new replies.