Subtract If Greater than Zero

Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a cell is greater than zero.

Let’s look at the example below. Here, We have two columns, C and D. We want to subtract C from D only if the value in D is Greater than Zero. If it’s not, we want Excel to return a blank value. This is achieved by using the following formula.

=IF(D3>0,C3-D3,"")

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend