|
|
|
|
#1
05-15-2015, 12:15 PM
|
|||
|
|||
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  
|
|
#2
05-15-2015, 08:05 PM
|
|||
|
|||
|
Assuming you've discovered the IFERROR function?
|
|
#3
05-17-2015, 06:50 AM
|
||||
|
||||
|
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
|
|
|
|
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 |
Windows 8 
Office 2013
Hybrid Mode