Empty cells plotted as zero.

		Microsoft Office Forums > Microsoft Excel > Excel
Empty cells plotted as zero.

01-23-2012, 07:39 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Empty cells plotted as zero.

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Hi Colin,

Try this:

=IF(Sheet1!E2>0,Sheet1!E2,NA())

because #N/A errors should be ignored.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vba, Is there a better way to test empty cells?	Hwyn	Excel Programming	2	11-14-2011 11:44 AM
Empty rules	rene.kamphuis@ciz.nl	Mail Merge	21	04-15-2011 12:34 AM
Shared Calendar Empty	worksmart	Outlook	0	01-21-2011 06:32 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Populate an empty .PAB file	imported_contiw	Outlook	2	08-17-2006 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:09 AM.