Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1128 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Janet_Janowiak
4 - Data Explorer
4 - Data Explorer

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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 %} )
Janet_Janowiak
4 - Data Explorer
4 - Data Explorer

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.