Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-01-2013, 04:41 AM
ColinC ColinC is offline Empty cells plotted as zero. Windows 7 64bit Empty cells plotted as zero. Office 2010 64bit
Novice
Empty cells plotted as zero.
 
Join Date: Dec 2011
Location: England
Posts: 9
ColinC is on a distinguished road
Default Empty cells plotted as zero.

In sheet 3 there is a column of figures (col. C)which builds up over time. When a group of four consecutive cells all have values in them the values are averaged and appear in cell P9 in sheet 4

=IF(COUNTBLANK(C13:C16)>0,"",AVERAGE(C13:C16))

This is working O.K. I now want to plot these averages but have the problem of empty cells being plotted as zero instead of being ignored.

=IF(Sheet3!P9>0,Sheet3!P9,NA())

I have had this problem before and have received advice from this forum concerning the NA() function. It has worked O.K. on similar programs but not this time. Help please.

Colin.

Last edited by ColinC; 03-01-2013 at 06:18 AM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Empty cells plotted as zero. Macro to delete rows with all empty cells ubns Excel Programming 2 08-14-2012 02:01 AM
Empty cells plotted as zero. Word Empty Cells - Why is it Chr(13) & Chr(7) tinfanide Word VBA 2 04-10-2012 01:34 AM
Apparently empty (blank) cells aren't empty daymaker Excel 3 03-08-2012 03:41 PM
Empty cells plotted as zero. ColinC Excel 2 01-23-2012 08:02 AM
Empty cells plotted as zero. Vba, Is there a better way to test empty cells? Hwyn Excel Programming 2 11-14-2011 11:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft