
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 21, 2023 07:18 PM - edited ‎Nov 21, 2023 07:20 PM
I have these two fields
Formula on Contract Yield % is this:
I need to replace the formula in the Contract Yield, to an IF formula.
More likely:
I already tried (IF({Contract Yield}=0,{Appraised Yield}
but it's not showing the correct results
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 21, 2023 08:39 PM
Airtable stores percents as decimals. Try comparing with 0.01 instead of 1:
IF(
{Contract Yield} > 0.01,
{Contract Yield},
{Appraised Yield}
)
Or maybe try this (depending on the result you want when {Contract Yield} is between 0 and 1%:
IF(
{Contract Yield} = 0,
{Appraised Yield},
{Contract Yield}
)
In either case, I think you should keep a two field system: one that just calculate the {Contract Yield} and another that determines which of the two yields to actually use. It is possible to put it all in one formula, but it gets to be a long, ugly formula that is harder to maintain.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 21, 2023 08:39 PM
Airtable stores percents as decimals. Try comparing with 0.01 instead of 1:
IF(
{Contract Yield} > 0.01,
{Contract Yield},
{Appraised Yield}
)
Or maybe try this (depending on the result you want when {Contract Yield} is between 0 and 1%:
IF(
{Contract Yield} = 0,
{Appraised Yield},
{Contract Yield}
)
In either case, I think you should keep a two field system: one that just calculate the {Contract Yield} and another that determines which of the two yields to actually use. It is possible to put it all in one formula, but it gets to be a long, ugly formula that is harder to maintain.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 21, 2023 10:42 PM
Thank you Kuovonne, Yes it really worked!
By any chance can you tell me what will be the long formula if we will put it all in one formula please?
We just really need to maintain the one field.
