| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
I know how to hide the formula if it equals zero, however can I eliminate
those cells from the cell that gives me a SUM with division in the formula? I get the error code of #DIV/0! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
You can eliminate the errors by using a formula like:
=IF(A5=0,"NA",B5/A5) The SUM() won't generate errors in that case "Diane" wrote: I know how to hide the formula if it equals zero, however can I eliminate those cells from the cell that gives me a SUM with division in the formula? I get the error code of #DIV/0! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
Diane,
It's better to eliminate the error by checking if the divisor is zero but to sum with those errors in the range try =SUMIF(A1:A12,""&0) Mike "Diane" wrote: I know how to hide the formula if it equals zero, however can I eliminate those cells from the cell that gives me a SUM with division in the formula? I get the error code of #DIV/0! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
