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

CONCATENATE Function

The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.

Read More »
Scroll to Top