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

C3PO

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

Mike TV

@C3PO

Try this:

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

Mike TV

@C3PO

Try this:

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

C3PO

@Mike TV

Worked like a charm. Thank you!!