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

[Janet_Janowiak]

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:

[kuovonne · Accepted solution]

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 …

Janet_Janowiak:

IF({Referral Name}}, “Field is Not Empty”),{Commission} {Referral %},"")*

Try this …

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

[Janet_Janowiak]

kuovonne:

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?

[kuovonne]

Janet_Janowiak:

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.