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, our Microsoft Excel training in Dorset, Hampshire and Wiltshire 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, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s