How do I get a formula calculating Total Salary to come back blank if = 0?


I have a "Total Salary" column that calculates the "Total Salary" using "Base Salary", "Commission", and "Bonus %" (see below). But sometimes the form I'm using doesn't need to capture base, commission, and bonus. So, my formula returns "0". I'd rather have it remain blank.

What do I need to add to the formula below?

=([Base Salary]@row + Commission@row + ([Base Salary]@row * [Bonus %]@row))

Thank You

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓


    Try this:

    =IF(([Base Salary]@row + Commission@row + ([Base Salary]@row * [Bonus %]@row))=0, "", ([Base Salary]@row + Commission@row + ([Base Salary]@row * [Bonus %]@row))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!