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.


📂  Download Excel File

Download free workbook from here:


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.

Dataset to execute if zero leave blank Excel formula

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.

Using the IF function to execute if zero leave blank Excel formula

  • 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.

Applying the IF function to execute if zero leave blank Excel formula

  • Finally, you will find the required result.

Result of using the IF function to execute if zero leave blank Excel formula

Undoubtedly, this technique is a very handy process to perform if zero leave blank Excel formula.

📕 Read More: 4 Easy Ways to Fill Blank Cells in Excel with 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.

Excel option changing to execute if zero leave blank Excel formula

  • 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.

Excel Options Table to execute if zero leave blank Excel formula

  • Eventually, you will see the desired result in front of you.

Result of changing Excel options to execute if zero leave blank Excel formula

Truly, we can simply apply the process to do if zero leave blank Excel formula.

📕 Read More: 4 Quick Ways to Insert 0 If Cell Is Blank in Excel

APPROACH

3. Adopting Custom Format

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.

The custom format in Excel to leave blank cell

  • Thirdly, select Number in Format Cells.
  • Tap Custom and type:

0;-0;;@

  • Fourthly, click OK.

  • Finally, you will see the results as required.

result of using the custom format to execute if zero leave blank Excel formula

In actuality, we can easily use the procedure to do if zero leave blank Excel formula.

📕 Read More: How to Fill Blank Cells in Excel with Go To Special (4 Easy Ways)

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.

Using the conditional format to leave zero blank cell

  • 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.

Format Cells dialogue box

  • Again you will see the dialogue box of Equal To.
  • Just tap OK.

  • Eventually, you will see the result as well.

Result of applying the conditional format in Excel

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

VBA code to Leave Excel Cell Blank If Formula Returns No Data

  • Then close the module and return to the sheet.
  • Fourthly, go to the View tab.
  • Select Macros and View Macros.

  • Finally, click on Run.

  • Consequently, the required result will appear to you.

Result of using the VBA code to Leave Excel Cell Blank If Formula Returns No Data

Undoubtedly, using VBA is the simplest way to leave cell blank in Excel if formula returns no data.

📕 Read More: How to Get Blank Cell Instead of Zero Using Formula in Excel


📄 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.


📝 Takeaways from This Article

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

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

Leave a reply

ExcelDen
Logo