by Richard on July 25th, 2009

Question

Help answer this question below.

If the result of a forumula is zero, I would like for Excel to display a blank cell rather than 0.00.

Like
Report

Share:: Facebook; Twitter; Other

Answers. Showing one answer.

See all 3 answers to this question.

by Umesh Shah on November 15th, 2009
Use Conditional formating if answer is zero select white phonts.
Comments
Add a comment...
- Like
- Report
No comments. Post one | Permalink

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Could someone give me a good definition of VLOOKUP in Excel?
by slimNanny on August 13th, 2011 | 1 person likes this
What are examples of Spreadsheet application software?
by tinmanEvil on August 13th, 2011 | 1 person likes this
No matter what cells I select, the freeze panes option always selects the first 15 rows to freeze. How do I fix this in Excel 2010?
by Nickname on October 8th, 2011 | 1 person likes this
I need a formula in Excel that does the following.. If the value in cell A1=X, then multiply cell B1 by 5..if A1=Y, then multiply B1 by 8.
by leslie2413 on September 1st, 2011 | 2 people like this
I have excel 2003. I get error: The formula in this cell refers to a range that has additional numbers adjacent to it. What does it mean?.
by stretch on August 21st, 2011 | 1 person likes this
More Microsoft Excel See only professionally researched Microsoft Excel questions

You're reading If the result of a forumula is zero, I would like for Excel to display a blank cell rather than 0.00.

Follow us on Facebook!

Related Ads

Professionally Researched

About Us

About Answerbag

Sitemap

Professionally Researched Questions

Legal

Privacy Policy

Terms of Use

Disclaimer

Ad Choices
Follow Us on Facebook

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!
Latest Tweet

What is a movie that was ignored you thought great? http://t.co/FsBFmVd7

Follow Answerbag on Twitter!

Answerbag

Question

If the result of a forumula is zero, I would like for Excel to display a blank cell rather than 0.00.

Answers. Showing one answer.

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

Can you help change my excel formula so it works? This is the formula i am using. It is used to give different responses depening on what number is in cell AE4, (A number between 1 & 5). It works fine but i would like a way to leave the cell blank or s

A date is in cell A1. There are deadlines 5 and 15 days after that date, so in the next 2 cells, i have =A1+5 and =A1+15. When nothing is in the 1st cell, they show 1/5/00 and 1/15/00. Id like those to be blank if no data is in the 1st. How can I do this?

In excel if the cell is blank i want to retrive it as 0 for that i gave a formula as follows =if(A2="","0",A2) But still it shows only the blank cell. Could you please help me on this.

In Excel, how do you determine and display the number of days between two dates? Example: Cell E19 (11/15/2007) Cell E20 (01/23/2008) Cell E19 (Reflect the number of days)

I would like to copy the contents of one cell into anothe cell but leave it blank if there is nothing to copy. I have the function =IF(B17.B17," ") which works if the cell is a number but no

Professionally Researched

How do I display U.S.& state flags on a pole?

How do I enter formulas in Excel to show not less than zero?

Can cell phones be used as ps3 mics?

Where are cell membranes found?

What is a plant cell structure composed of polysaccharide?

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Question

If the result of a forumula is zero, I would like for Excel to display a blank cell rather than 0.00.

Answers. Showing one answer.

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

Answerbag.com Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!