Help with conditional formatting of a formula


I have a formula i'm trying to figure out where I'm going wrong:

=IF(NOT(ISBLANK([Rate]@row)SUM(([Registration Balance]@row * Rate@row) - [USD Amount]@row)))

The Rate column is populated via a dropdown to one of 3 different values, but when it is not yet populated It returns "#INVALID OPERATION" where I want it to return a blank cell if all the above variables are not present.

Can anyone help me with a way to address this?

Thank you in advance for any help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!