# Creating multiple conditions for calculated property

**URL:** <https://community.hubspot.com/t/creating-multiple-conditions-for-calculated-property/103023>\
**Category:** CRM\
**Tags:** how-to\
**Created:** [March 20, 2024, 5:32pm UTC](https://community.hubspot.com/t/creating-multiple-conditions-for-calculated-property/103023 "2024-03-20T17:32:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Snapdragon23](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@Snapdragon23](https://community.hubspot.com/u/Snapdragon23)\
**Post date:** [March 20, 2024, 5:32pm UTC](https://community.hubspot.com/t/creating-multiple-conditions-for-calculated-property/103023/1 "2024-03-20T17:32:36Z")

</div>

Hi There,

I am needing to create a calculated property around “forecasted amount” that takes into account several different factors. Essentially I have created custom fields to separate out renewal amount and expansion amount as components of the same deal. I need to now be able to weight those two values differently and then create a sum of the overall forecasted value.

**Here is an example of how that might look to calculate this new field “Overall Weighted Amount”**

If in stage A, Stage, C and Stage F: [Amount] \*[Deal Probability]

If in Stage b, d, or E: [( Renewal amount \*80 ) + (Expansion Amount \*[Deal Probability]

I need help knowing if there is a way to create a single calculated fields with the conditions above.

Thanks in advance for your help!

---

<div class="post-metadata">

**Author:** ![RSchweighart](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rschweighart/32/28924_2.png) [@RSchweighart](https://community.hubspot.com/u/RSchweighart)\
**Post date:** [March 20, 2024, 9:10pm UTC](https://community.hubspot.com/t/creating-multiple-conditions-for-calculated-property/103023/2 "2024-03-20T21:10:55Z")

</div>

Hi @Snapdragon23,

Are you on any Pro or Enterprise plan?

If so, have you tried [creating a calculated property](https://knowledge.hubspot.com/properties/create-calculation-properties)? It seems doable with the logic you outlined.

Another option could be to [create a workflow](https://knowledge.hubspot.com/workflows/create-workflows) or two with the criteria you mentioned. I believe you’d need an Ops Hub Pro subscription to leverage the Custom code step.

Curious to hear if you’ve tried either of these options!

Best,

_ **Ryan Schweighart** _

Whole Hart Impact, LLC

[whimpact.co](http://www.whimpact.co)

_I help businesses with HubSpot and Zapier._

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [March 21, 2024, 5:35am UTC](https://community.hubspot.com/t/creating-multiple-conditions-for-calculated-property/103023/3 "2024-03-21T05:35:09Z")

</div>

Hi @Snapdragon23,

Yes, that should work, see the examples here 🙂 [Create calculation and rollup properties](https://knowledge.hubspot.com/properties/create-calculation-properties#examples)

Best regards!

---

<div class="post-metadata">

**Author:** ![Snapdragon23](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@Snapdragon23](https://community.hubspot.com/u/Snapdragon23)\
**Post date:** [March 21, 2024, 7:38pm UTC](https://community.hubspot.com/t/creating-multiple-conditions-for-calculated-property/103023/4 "2024-03-21T19:38:24Z")

</div>

@RSchweighart @karstenkoehler I have taken a look at this article but am running into errors actually building in the formulas. Any idea how you would specifically format this?

---

<div class="post-metadata">

**Author:** ![RSchweighart](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rschweighart/32/28924_2.png) [@RSchweighart](https://community.hubspot.com/u/RSchweighart)\
**Post date:** [March 25, 2024, 11:13pm UTC](https://community.hubspot.com/t/creating-multiple-conditions-for-calculated-property/103023/5 "2024-03-25T23:13:00Z")

</div>

Hi @Snapdragon23,

What if you tried something like this?

```lia-code-sample
if(
 [Stage] = "A" or [Stage] = "C" or [Stage] = "F", 
 [Amount] * [Deal Probability], 
 if(
 [Stage] = "B" or [Stage] = "D" or [Stage] = "E", 
 ([Renewal Amount] * 0.8) + (Expansion Amount * [Deal Probability]), 
 0
 )
)

```

(updated 3/25/24 at 7:21pm EST)

It is basically two IF statements, and if none of the conditions are met, it will return 0.

Best,

_ **Ryan Schweighart** _

Whole Hart Impact, LLC

[whimpact.co](http://www.whimpact.co)

_I help businesses with HubSpot and Zapier._

---

<div class="post-metadata">

**Author:** ![ArcusData](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/arcusdata/32/76793_2.png) [@ArcusData](https://community.hubspot.com/u/ArcusData)\
**Post date:** [March 23, 2025, 10:39pm UTC](https://community.hubspot.com/t/creating-multiple-conditions-for-calculated-property/103023/6 "2025-03-23T22:39:42Z")

</div>

@RSchweighartThanks for your example here.