Microsoft Office Forums - View Single Post - Empty cells plotted as zero.

Thread: Empty cells plotted as zero.

View Single Post

Old

01-23-2012, 07:39 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Hi Colin,

Try this:

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

because #N/A errors should be ignored.

Reply With Quote