Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Help with basic IF statement

Topic Labels: Formulas
3445 12
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

This seems like ridiculously easy formula to write, but I’m stymied.

IF({Paid} ≥ {120%}, ({Paid} - FMV),0)

If the person Paid more than 120% (120% is a column calculating 120% of the Fair Market Value), then the value of their tax receipt is the amount the Paid - FMV. Otherwise, their receipt is 0.

It seems so easy! But none of my attempts work. What am I missing?


12 Replies 12

Thank you, @ScottWorld. I was not an expert at Filemaker Pro either, but I did love it and had managed to make formulas work. That probably IS why I thought ≥ would work!

Filemaker was very expensive to upgrade, though, and it was hard for my business partner (who lives in another city and is not a techie) to use my databases. AirTable’s online base system is fantastic for our situation when it works.


Yes, FileMaker is expensive & can be difficult to upgrade. (On the other hand, it is a full-blown programming language with infinite customizability.)

I feel blessed that I am both an Airtable developer AND a FileMaker developer — because I’ve got my clients’ needs covered, no matter what sort of a project they’re trying to tackle! :slightly_smiling_face:

Based on our thread here, I typed up a product suggestion regarding making error messages easier to understand in Airtable — maybe you can chime in there with your own experience & opinion:

@Jeremy_Oglesby, yes, I love the idea of writing formulas in text editor software, so it can catch mistakes like missing parentheses. I enjoy using BBEdit on the Mac — what do you use? Also, is there a certain “language” that you enable in your text editor software while you’re writing your Airtable formulas, in order to get syntax coloring as you’re typing? BBEdit will apply coloring based on what language you choose (but they obviously don’t have Airtable listed as a language). Is there a language that is “pretty close” to the same formatting as Airtable?