Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Re: Need "If" Statement to calculate referral amt if there is a name in the referral name field

Solved
Jump to Solution
68 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’ve been fighting this and researching long enough. here is what I currently have that doesn’t work: IF({Referral Name}}, “Field is Not Empty”),{Commission}{Referral %},"")*

Explained:
If Referral Name field is not blank or empty,
Calculate Commission field multiplied by Referral %
Otherwise, leave return a blank field.

Help! :slightly_smiling_face:

1 Solution

Accepted Solutions

Welcome to the Airtable community!

When translating your ideas from English into Airtable’s formula language, the resulting sentence has different words and punctuation.

Instead of this …

Try this …

IF( {Referral Name}, {Commission} * {Referral %} )

See Solution in Thread

3 Replies 3

Welcome to the Airtable community!

When translating your ideas from English into Airtable’s formula language, the resulting sentence has different words and punctuation.

Instead of this …

Try this …

IF( {Referral Name}, {Commission} * {Referral %} )

Thanks for the welcome, Kuovonne! And, more importantly, thank you for the solution. It works but I don’t understand why I don’t need the other half of the logic statement. Is it because if the condition is NOT met I don’t want anything to happen?

Correct. Since you don’t want a value if the condition is not met, you can omit the last part of the IF. In fact, when you don’t want a value if the condition is met, it is better to omit the last part of the IF than to include something. If you include the empty text string ("") then your answer will be converted to a text string, even when you want a number.