Calculator Formula

Ask the Community Customization
1

Hi, I’ve been battling the formulas for 24 hours now and getting a little nearer to being able to make a printing calculator but hitting a wall again.

The url is Elfsight

I am building it piece by piece now to ensure it works before introducing the next of the 10 fields.

This works:

IF(AND({{m7xx37ql}}==“1”,{{m7xtoivt}}==“1”),
IF({{c4w5ykl9}}==“1”,43,
IF({{c4w5ykl9}}==“2”,44,
IF({{c4w5ykl9}}==“5”,
IF({{9aw2q551}}<32,47,
IF({{9aw2q551}}==“32”,51,
IF({{9aw2q551}}==“36”,55,
IF({{9aw2q551}}==“40”,59,
IF({{9aw2q551}}==“44”,62,
IF({{9aw2q551}}==“48”,66,
IF({{9aw2q551}}==“52”,70,0)
)
)
)
)
)
),
0)
)
),
0)

But when i try adding three other variables for the CHOOSE A SIZE, it’s giving me constant invalid errors. I’m guessing it’s the location of the AND, IF or ORs?

IF(AND({{m7xx37ql}}==“1”,OR({{m7xtoivt}}==“1”,{{m7xtoivt}}==“4”,{{m7xtoivt}}==“5”,{{m7xtoivt}}==“6”)),IF({{c4w5ykl9}}==“1”,43,IF({{c4w5ykl9}}==“2”,44,IF({{c4w5ykl9}}==“5”,IF({{9aw2q551}}<32,47,IF({{9aw2q551}}==32,51,IF({{9aw2q551}}==36,55,IF({{9aw2q551}}==40,59,IF({{9aw2q551}}==44,62,IF({{9aw2q551}}==48,66,IF({{9aw2q551}}==52,70,0))))))),0))),0)

Any help very much appreciated.

3 Likes
3

Hi there, @Mike_Heaton and welcome to the Community :wave:

I’ve forwarded your request to the devs and will get back to you on Monday :slightly_smiling_face:

2 Likes
4

Star, thanks Max

3 Likes
5

Hi there, @Mike_Heaton :wave:

There were redundant “” symbols and OR conditions (there can’t be more than 2 OR) in the formula. However, we’ve adjusted and now everything is working fine :slightly_smiling_face:

1 Like
6

Thank you Max. Works! This is the first set of options our form needs to give pricing on, so I will go ahead and add the others as additional sections now in the formula box. Or did you mean for the entire calculator formula, you can only have a maximum of two ‘OR’?

1 Like
7

The maximum of two OR is for one specific formula :slightly_smiling_face: