Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Difference between A & B fields, but blank if B has no value

Topic Labels: Formulas
900 4
Showing results for 
Search instead for 
Did you mean: 

Hello! I’ve been struggling with a formula and am hoping for some help.

I have an $Invoice field, a $Paid field, and I’d like to have a Difference field (i.e., show $0 if a client paid their invoice in full, or show the balance due if an invoice is short-paid. I would also like the difference field to be blank if there is nothing in the $Paid field… that’s where I’m struggling.

Any suggestions?

4 Replies 4

Try this:

IF({$Paid}=BLANK(), BLANK(), {$Invoice} - {$Paid})

That worked! Thanks so much!

IF({$Paid},{$Invoice}-{$Paid}) will work as well. It takes advantage of a couple of Airtable shortcuts:

  • IF({Field},...) is an implicit test for {Field} != BLANK().
  • An IF() statement whose test evaluates to false but lacks a second (‘ELSE’) branch returns BLANK().

Great points. I discovered those shortcuts after writing that comment, but didn’t think to backtrack and update it.