Sometimes we use a formula in Microsoft Excel and the calculated result becomes negative, which is unimportant. Instead of showing negative values, we want to display the cell blank. It can be done in 2 ways in Excel. Are you looking for solutions to return blank cells if the cell value is negative? In this article, weâ€™ll discuss how an Excel formula return blank if cell value is negative.

## How to Use Excel Formula to Return Blank If Cell Value Is Negative: 2 Suitable Ways

There are **2** suitable ways to return blank by excel formula if the cell value is negative in **Excel**. One is by using **the IF function** and the another is by using the **Format Cells** option. In order to describe the methods, we have taken a dataset like the following figure where we have **5** products, their **Buying Price** and **Selling Price**. We will calculate the **Profit** by subtracting the **Selling Price** from the **Buying Price** and show a blank cell if the value is negative.

### 1. Applying IF function

Applying **the IF function** is the easiest way to return a blank cell when the formula value is negative. All we need is to use a simple **Excel** formula using **the IF function** where we will write the formula in such a way that if the calculated value is negative, it will return a blank cell. In order to apply this method, follow the steps below.

**Steps:**

- First, select cell
**E5**and type the following formula:

`=IF(D5-C5<0,"",D5-C5)`

- Then, press
**Enter**and it will calculate the profit. If the profit is positive like the image below, it will display the profit.

- Second, select cell
**E5**and drag the**Fill Handle**down to the entire column**Profit**. - As a result, it will calculate profits for the
**5**products and when the calculated profit is negative, it will show blank cells like the image below.

**Read More:Â **Excel Formula to Return Zero If Negative Value is Found

### 2. Use of Format Cells Option

In order to return blank if cell value is negative, we can also use the **Format Cells** option. To demonstrate the example, we have taken the previous dataset like the following figure where we have **5** products, their **Buying Price** and **Selling Price**. We will calculate the **Profit** by subtracting the **Selling Price** from the **Buying Price** and show a blank cell if the value is negative. Follow the steps below to apply this method.

**Steps:**

- To begin with, select cell
**E5**and type the following formula:

`=D5-C5`

- Then, press
**Enter**and it will calculate the profit as shown below.

- After that, select cell
**E5**and drag the**Fill Handle**down to the entire column**Profit**. - As a result, it will calculate profits for the
**5**products like the below one.

- Subsequently, select cells (
**E5:E9**) >>**Right-click**on your mouse >> select**Format Cells**from the pop-up window.

- As a result, the
**Format Cells**window will appear. - Then, select
**Custom**from the**CategoryÂ**option. - Next, type â€œ
**0;””**â€œ in the**TypeÂ**box. - Then, click on
**OK**.

- Finally, it will calculate profits for the
**5**products and when the calculated profit is negative, it will show blank cells like the image below.

**Read More:Â **Excel Formula If Cell Contains Negative Number

## How to Display Blank Cells for Zeroes in Excel

Often we use a formula in **Microsoft Excel **and the calculated result becomes **zero**, which is unimportant. Instead of showing zeroes, we want to display the cell bank. Applying **the IF function** is the easiest way to return a blank cell when the formula value is **zero**. All we need is to use a simple **Excel** formula using **the IF function** where we will write the formula in such a way that if the calculated value is zero, it will return a blank cell. In order to apply this method, follow the steps below.

**Steps:**

- Firstly, select cell
**E5**and type the following formula:

`=IF(D5-C5=0,"",D5-C5)`

- Then, press
**Enter**and it will calculate the profit. If the profit is positive like in the image below, it will display the profit.

- Secondly, select cell
**E5**and drag the**Fill Handle**down to the entire column**Profit**. - As a consequence, it will calculate profits for the
**5**products and when the calculated profit is**zero**, it will show blank cells like the image below.

**Read More:** How to Make a Group of Cells Negative in Excel

## Things to Remember

- Using
**the IF function**is the easiest way to return a blank cell if the calculated value from**Excel**formula is negative. - If you use the
**Format Cells**option, your particular format for those cells will be lost and it will display the customized format you have written.

**Download Practice Workbook**

You can download the** Excel workbook** from here.

## Conclusion

Hence, follow the above-described steps. Thus, you can easily learn how to return blank using an Excel formula if the cell value is negative. Hope this will be helpful. Donâ€™t forget to drop your comments, suggestions, or queries in the comment section below.

## Related Articles

- How to Add Negative Numbers in Excel
- How to Show Negative Numbers in Excel
- How to Put a Negative Number in Excel Formula
- [Fixed!] Excel Not Adding Negative Numbers Correctly
- How to Count Negative Numbers in Excel

**<< Go Back to Negative Numbers in Excel | Number Format | Learn Excel**