Formula to hide '0' from blank referenced cells

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to hide '0' from blank referenced cells

05-07-2014, 09:50 AM

gebobs

Windows 7 64bit Formula to hide '0' from blank referenced cells

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

{=if(isblank(RawData!B:B),"",RawData!B:B)}

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
multiple conditions, and blank cells with the countifs function	jaden0605	Excel	1	03-30-2014 01:50 AM
Join cells together separated by ; when some are blank	leemoreau	Excel	3	11-03-2013 11:22 AM
Selecting blank cells in criteria	apolloman	Excel	6	08-24-2011 05:38 AM
How to organize and insert blank cells between a huge number of data?	tareq	Excel	12	09-29-2010 02:12 PM
Using both drop down lists and blank cells for text	voltarei	Word	0	03-18-2010 04:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:04 PM.