Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-15-2015, 12:15 PM
Jackie Jackie is offline show 0 instead of DIV/0 Windows 8 show 0 instead of DIV/0 Office 2013
Novice
show 0 instead of DIV/0
 
Join Date: Nov 2014
Posts: 18
Jackie is on a distinguished road
Default show 0 instead of DIV/0

Hi

When I am trying to add the following column cells I am getting DIV/0 as some of these cells themselves have DIV/0 as there is no data results in some of them.........Please can anyone tell me how to show 0 instead of DIV/0

=SUM(M11+S11+Y11+AE11+AK11+AQ11+AW11+BC11)



Thank you
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
PPT show did not show up Jaysne PowerPoint 0 03-03-2014 09:00 PM
Question: Hyperlink to other show, but close the current show habibfikri PowerPoint 0 12-26-2010 02:37 AM
PP 2010 .avi file plays during slide show, but causes the slide show to loop to begin VictorS PowerPoint 0 10-16-2010 10:23 AM
show 0 instead of DIV/0 if (neg) show 0 ram1000 Excel 2 09-16-2008 02:30 PM
Show As Tos Outlook 0 07-08-2008 10:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 PM.


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