Skip to main content
Solved

Using IF Formula

  • November 22, 2023
  • 2 replies
  • 44 views
I
Forum|alt.badge.img+8

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


Best answer by kuovonne

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

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • Answer
  • November 22, 2023

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.

I
I
Forum|alt.badge.img+8
  • Imee_Lee
  • Author
  • Known Participant
  • November 22, 2023

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.

Terms & ConditionsAccessibility statement