show 0 instead of DIV/0

		Microsoft Office Forums > Microsoft Excel > Excel
show 0 instead of DIV/0

FAQ

Thread Tools

Display Modes

05-17-2015, 06:50 AM

Pecoflyer

Windows 7 64bit show 0 instead of DIV/0

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Hi
in your formula the SUM function is redundant
=M11+S11+Y11+AE11+AK11+AQ11+AW11+BC11 will also do the trick

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

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
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 09:43 AM.