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:
Best answer by kuovonne
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 %} )
+29Welcome 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?
+29Thanks 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.