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

Re: Need help with if/then formula

1164 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to make a simple formula that would show a total amount available between two fields if a third field had a particular category in it.

IF {Type of Credit}=“Credit Card” then({Total Credit}-{Total Amount Due:})

I have not been successful getting the syntax right, but I am a new user to airtable and am probably still thinking like a spreadsheet…

Thank you for your help! Colleen

2 Replies 2

You’re very close:

    {Type of Credit}='Credit Card',
    {Total Credit}-{Total Amount Due:}

That will leave the field blank if {Type of Credit} is anything other than 'Credit Card'.

Thank you W_Vann_Hall, I appreciate the quick response. I was close, but not correct!