|
|
#1
05-28-2016, 06:41 PM
|
|||
|
|||
How to prevent #DIV/0!
I am wondering how to insert a formula into a cell which will display a blank result when the values in the cells being accessed are blank.
For example I have formula of =F4/C4*100 which displays #DIV/0! when (cells) F4 and or C4 are blank. Thanks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| prevent repetition in form | johnbest | Word VBA | 2 | 03-31-2015 11:42 PM |
 Prevent Copying and Pasting
|
Jimmy Tsawo | Excel | 3 | 02-20-2014 03:54 AM |
|
How can I PREVENT headings I don't want?
|
peytontodd | Word | 3 | 11-23-2013 05:08 PM |
| Prevent Overlap of Appointments | irab88 | Outlook | 0 | 08-03-2010 10:43 AM |
| text box, prevent from printing | Tanya | Word | 0 | 02-05-2010 06:57 AM |
Windows XP 
Office 2010 32bit
Threaded Mode