| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dividing by zero
I made a template where one column is to display the result of a formula of numbers entered into other columns. The formula contains a division, which prompts the result cell to display #DIV/0! until a number is entered into the cell that corresponds with the denominator in the formula. Although it doesn't affect the functionality of the template, I don't want the result column to show #DIV/0! if the denominator cell is blank. Is there a way to do this? Thanks in advance! Excel 2003 -- careyc ------------------------------------------------------------------------ careyc's Profile: http://www.excelforum.com/member.php...o&userid=26064 View this thread: http://www.excelforum.com/showthread...hreadid=523709 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cumulative adding and dividing problems! | Excel Discussion (Misc queries) | |||
| Formulas when dividing with negative numbers | Excel Worksheet Functions | |||
| New installed Excel2003 keeps dividing any number entered in any . | Excel Discussion (Misc queries) | |||
| What is the formula for dividing a number by 4 in excel | Excel Worksheet Functions | |||
| Where do i change the settings my normal template is dividing all. | Setting up and Configuration of Excel | |||
Threaded Mode
