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,"")