This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
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.
