Help

Using IF Formula

Topic Labels: Formulas
Solved
Jump to Solution
556 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Imee_Lee
6 - Interface Innovator
6 - Interface Innovator

I have these two fields 

Screenshot 2023-11-22 at 11.14.32 AM.png

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
 
Can you please help me what is the correct formula to make it work?

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

but it's not showing the correct results


Screenshot 2023-11-22 at 11.20.12 AM.png
1 Solution

Accepted Solutions
kuovonne
18 - Pluto
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.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
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.

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.