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 Reply

SUMIF Function

The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common

Read More »
Scroll to Top