Using blanks in a Microsoft Excel formula

If you want to create a calculation in a cell based on values in another cell and copy it down the rest of the column, what do you do if you want a blank to be returned if the original cell was a blank?

If our original formula was to work out 10% of whatever is in B2, the formula would be:


If B2 was blank, the resulting formula would return an answer of 0.

If we wanted to ensure we returned a blank if B2 was blank, the required formula would be:


The double quote marks indicate that a blank should be returned if the result is true.

Find out more about our Microsoft Excel training London, UK or our Microsoft Excel training Sydney, Australia.


About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Excel and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s