# Using IF Formula

Topic Labels: Formulas
Solved
556 2
cancel
Showing results for
Did you mean:
6 - Interface Innovator

I have these two fields

Formula on Contract Yield % is this:

({Contract Rent PW}*52)/{Purchase Price}

I need to replace the formula in the Contract Yield, to an IF formula.

More likely:
When the result on Contract Yield is 0%,

If Contract yield = above 1%, use Contract yield formula, but if it's 0% I need to use Appraised Yield

I already tried (IF({Contract Yield}=0,{Appraised Yield}

but it's not showing the correct results

1 Solution

Accepted Solutions
18 - Pluto

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.

2 Replies 2
18 - Pluto

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.

6 - Interface Innovator

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.