[SOLVED] Bug?

Ok, don't worry, I have a solution

Creating a new formula:
( ( 134 / 100 ) * ( $woo_price_calc_3 / 100 ) * $price * $woo_price_calc_10 + 9.5 ) + ( $woo_price_calc_11 * ( ( 134 / 50 ) + ( $woo_price_calc_3 / 50 ) * 2 * 0.6 * $woo_price_calc_10 ) )

$woo_price_calc_3: input with values from 1 to X
$price: 9
$woo_price_calc_10: list with values from 1 to 15
$woo_price_calc_11: "boolean" list with value 0 or 1

Hi Emilio,

Is this problem related to the other one?

If not please open another question

Best regards,
Enrico

Is there any way to make a boolean formula or use an "if" statement?

Kind regards.

Hi Emilio,

24,24 it's the right result.

Probabily you are doing manual calculator errors.

I'm attaching the XLS document I used to do calculations, as you can see the result with your suggested input parameters is 24,24

Best regards,
Enrico

If you have a $woo_price_calc_3 with 100, $woo_price_calc_10 with 1 and $woo_price_calc_11 with 0 you must get 21,56 €, but you get 24,24 €, 2,68 € extra. Why?

if you have the same values but $woo_price_calc_11 with 0.6 you get the wright price, 26,64 €

Try it, please.

Kind regards.

Hi Emilio,

I tried to setup your calculator, but I get 12,30 as result which is fine. I checked the result with Excel. What result do you get?

In the meanwhile could you please send to altoswebsolutions.com/contact-us your wp-admin and FTP access credentials?

Best regards,
Enrico

This is the formula:
( ( 134 / 100 ) * ( $woo_price_calc_3 / 100 ) * $price * $woo_price_calc_10 + 9.5 ) + ( ( 134 / 50 ) + ( $woo_price_calc_3 / 50 ) * 2 * $woo_price_calc_11 * $woo_price_calc_10 )

$woo_price_calc_3: input with values from 1 to X
$price: 9
$woo_price_calc_10: list with values from 1 to 15
$woo_price_calc_11: "boolean" list with value 0 or 0.6

Where's the issue?

Kind regards.

Hi, I created a formula with two formula sums with a "boolean" list with two vakues: 0.6 & 0.

The bug is generate by 0 value. When the formula made the calculations with 0,6 value everything works fine, but when it run with 0 value return the calculation plus 2,68 €. Why?

That value is the minimum value returned with all fields with default values.

Any help?

Kind regards.