Skip to main content

Can you help me create an Excel 2010 formula for displaying blank cells?

April 16, 2014 at 12:10AM:

I need an Excel 2010 formula that


1) displays whatever the value is of a given cell but

2) if there is no value there – it displays the cell as a blank (at the moment whenver I use the “=” function for a cell that is blank, I’m getting “0.0″ in the cell I enter the formula in.


Say:


A1 is: 18500

A2 is: (blank)

________________________


What formula would I use in a different cell to display A1 & A2 respectively with A2 showing as a blank instead of 0.0?


Post and answer: Can you help me create an Excel 2010 formula for displaying blank cells?





Read Question - Answers: MakeUseOf Answers
Labels:

Comments

Post a Comment

What's new?

Popular posts from this blog

Protect Your email address from Spam!

Spam emails are the worst problem an email user always face. Though there are no hard and fast rules or techniques to stop the spam apart from the email providers Spam Filters or Controllers. You would possibly have published your email address on web-pages or a blog from where the spammers may crawl and catch it, just like the search engine crawlers do for your keywords. So, here is a technique to stop them from catching [auto crawling]. Create an image/ graphics of your email address. There are many websites proving you a free email graphics of your email address, but I found couple of them easy to do so. The image below is a demonstration of how you can easily create a graphic version of your email and use the small code on your website / blog to display it. You may do this with any graphics software but doing this online would be much easy ! This would help you to protect your email address. Try creating your email address with: Domain Tools and Safe Mail
Post a Comment
Read more