# 4 Ways to Leave Blank If Cell Contains Zero with Excel Formula

Sometimes we need to execute if zero leave blank formula in Excel. In this article, we are going to show you how to execute if zero if leave blank formula in Excel with 4 easy approaches. We have also included some relevant concerns at the end of this article. So, let’s get started.

## Learn to Leave Blank If Cell Contains Zero with Excel Formula with These 4 Approaches

While writing this article, “If Zero Leave Blank Excel Formula”, we’ve considered a dataset that contains approximately 5 columns and 14 rows. In this dataset, we added Name, Income, Expenditure, and Savings to make you better understand. But if you want, you can change the entities and put your own values. APPROACH

### 1. Using IF Function

One of the best ways to execute if zero leave blank in Excel formula is using the IF function. You can do it very easily if you follow the given steps.

⬇️⬇️ STEPS ⬇️⬇️

• Initially, go to the Excel worksheet.
• Secondly, Select cell E6.
• Thirdly, write the following function there.

=C6-D6

• Now tap Enter. • You will see the cells like below. • Fourthly, select cell E6 and write down the given formula.

=IF(C6-D6=0,””,C6-D6)

• Now press Enter. • Finally, you will find the required result. Undoubtedly, this technique is a very handy process to perform if zero leave blank Excel formula.

APPROACH

### 2. Changing Excel Advanced Options

Another way to execute if zero leave blank in Excel is by changing the Excel option. This procedure is not very difficult rather you can do it with ease. You just need to follow the below steps.

⬇️⬇️ STEPS ⬇️⬇️

• Primarily, go to the File tab. • Secondly, select Options. • Now you will find Excel Options.
• Go to the Advanced option.
• Select Approach 2 for Display options for this worksheet.
• Leave Show a zero in cells that have zero value unchecked.
• Thirdly press OK. • Eventually, you will see the desired result in front of you. Truly, we can simply apply the process to do if zero leave blank Excel formula.

APPROACH

Adopting custom format is another way to execute if zero leave blank Excel formula. This process is simple enough that you can complete it without difficulty. Just adhere to the instructions listed below.

⬇️⬇️ STEPS ⬇️⬇️

• Initially, go to the Home tab.
• Secondly, select Number and then More Number Formats. • Thirdly, select Number in Format Cells.
• Tap Custom and type:

0;-0;;@

• Fourthly, click OK. • Finally, you will see the results as required. In actuality, we can easily use the procedure to do if zero leave blank Excel formula.

APPROACH

### 4. Applying Conditional Formatting

Applying conditional formatting is one of the greatest methods for carrying out the if zero leave blank in Excel calculation. If you follow the instructions, you can accomplish it pretty quickly.

⬇️⬇️ STEPS ⬇️⬇️

• Firstly, go to the Home tab.
• Select Conditional Formatting and then Highlight Cells Rules.
• Now select Equal To. • Thirdly, you will see a dialogue box name Equal To.
• Now write 0 in Format cells that are EQUAL TO and Custom Format. • Fourthly, select Font in Format Cells.
• Choose White, Background 1 for Theme Colors.
• Fifthly, click on OK. • Again you will see the dialogue box of Equal To.
• Just tap OK. • Eventually, you will see the result as well. Without a doubt, using this method is a really useful activity.

📕 Read More: 3 Ways to Fill Blank Cells with Text in Excel

## How to Leave Excel Cell Blank If Formula Returns No Data

If you want to leave Excel cell blank if the formula returns no data then this portion is especially for you. You can follow the given steps to achieve the process.

⬇️⬇️ STEPS ⬇️⬇️

• Initially, go to the Excel sheet.
• Secondly, press Alt+F11.
• It will open a VBA window.
• Thirdly, Insert a Module. • Now paste the given code on that Module.

Code

``````Sub Leave_Blank_Cell()
Dim y As Range
For Each y In Range("B6:E14")
If y.Value = 0 Then y.Value = " "
Next y
End Sub`````` • Fourthly, go to the View tab.
• Select Macros and View Macros. • Finally, click on Run. • Consequently, the required result will appear to you. Undoubtedly, using VBA is the simplest way to leave cell blank in Excel if formula returns no data.

## 📄 Important Notes

While carrying out the procedures mentioned above, you should be aware of the following:

🖊️  You need to be careful while using the Excel function.

🖊️   While intending to use the VBA code, you need to be conscious.

Several points can be gleaned from a summary of the entire article.

📌  Firstly, we’ve used the IF function to execute if zero leave blank in Excel formula.

📌  Secondly, we changed the Excel option.

📌  Thirdly, we applied a custom format.

📌  Belatedly, we adopted a conditional formatting procedure.

📌  Finally, we tried to show you how to leave Excel cell blank if formula returns no data.

## Conclusion

We wish that you would be able to execute if zero leave blank Excel formula using this article. Several methods have been shown here, so you can easily follow which one is best suited for you. If there is any skepticism in your mind, feel free to ask me in the comment. In the end, to learn more about Excel tactics, we recommend you to visit our website www.ExcelDen.com.

## Related Articles

(Visited 56 times, 1 visits today) #### Jonayed

Hello! My name is Jonayed. I've completed my graduation from BUET in Naval Architecture & Marine Engineering. As Excel is very interesting to me, I like to do various types of research regarding Excel. My inquisitive nature drives me to find solutions to different types of problems with Excel.

We will be happy to hear your thoughts 