| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
#DIV/0
How can you override a DIV/O error in a master sheet to come up as just a 0?
|
|
#2
|
|||
|
|||
|
Presumably the #DIV/0 is a result of a formula. The solution is to test the
divisor for 0, and if so take one course, else effect the formula. As an example =IF(A2=0,0,A1/A2) -- HTH RP (remove nothere from the email address if mailing direct) "Todd Nelson" wrote in message ... How can you override a DIV/O error in a master sheet to come up as just a 0? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
| How do i make a sum formula ignore #div/0! errors in the range | Excel Worksheet Functions | |||
| #DIV/0!.......how to get rid of it | Excel Discussion (Misc queries) | |||
| replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
| # DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
