# Calculator Formula

**URL:** <https://community.elfsight.com/t/calculator-formula/105685>\
**Category:** Customization\
**Tags:** calculator\
**Created:** [March 7, 2025, 3:00pm UTC](https://community.elfsight.com/t/calculator-formula/105685 "2025-03-07T15:00:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mike\_Heaton](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/mike_heaton/32/58200_2.png) [@Mike\_Heaton](https://community.elfsight.com/u/Mike_Heaton)\
**Post date:** [March 7, 2025, 3:00pm UTC](https://community.elfsight.com/t/calculator-formula/105685/1 "2025-03-07T15:00:34Z")

</div>

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](https://dash.elfsight.com/widget/86fc4811-e905-4f50-ad5a-838bc16a01dc)

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.

---

<div class="post-metadata">

**Author:** ![Max](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/max/32/710_2.png) [@Max](https://community.elfsight.com/u/Max)\
**Post date:** [March 7, 2025, 3:28pm UTC](https://community.elfsight.com/t/calculator-formula/105685/3 "2025-03-07T15:28:25Z")

</div>

Hi there, @Mike_Heaton and welcome to the Community 👋

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

---

<div class="post-metadata">

**Author:** ![Mike\_Heaton](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/mike_heaton/32/58200_2.png) [@Mike\_Heaton](https://community.elfsight.com/u/Mike_Heaton)\
**Post date:** [March 7, 2025, 3:33pm UTC](https://community.elfsight.com/t/calculator-formula/105685/4 "2025-03-07T15:33:55Z")

</div>

Star, thanks Max

---

<div class="post-metadata">

**Author:** ![Max](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/max/32/710_2.png) [@Max](https://community.elfsight.com/u/Max)\
**Post date:** [March 10, 2025, 10:59am UTC](https://community.elfsight.com/t/calculator-formula/105685/5 "2025-03-10T10:59:08Z")

</div>

Hi there, @Mike_Heaton 👋

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 🙂

---

<div class="post-metadata">

**Author:** ![Mike\_Heaton](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/mike_heaton/32/58200_2.png) [@Mike\_Heaton](https://community.elfsight.com/u/Mike_Heaton)\
**Post date:** [March 10, 2025, 1:07pm UTC](https://community.elfsight.com/t/calculator-formula/105685/6 "2025-03-10T13:07:45Z")

</div>

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’?

---

<div class="post-metadata">

**Author:** ![Max](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/max/32/710_2.png) [@Max](https://community.elfsight.com/u/Max)\
**Post date:** [March 10, 2025, 1:21pm UTC](https://community.elfsight.com/t/calculator-formula/105685/7 "2025-03-10T13:21:10Z")

</div>

The maximum of two OR is for one specific formula 🙂