| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Div/0 error
I get a div/0 in this formula if the sum f7:g7 is blank. I need to have this
formula to either show blank or zero instead it shows the error. I need it to show 0 or blank because at the end of the day I need the totals of the column, if there is the error I can not total this column. This formula is used to figue chemical weights in water treatment. Thanks Scott =if(x160,x16*f4)/sum(f7:g7) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I prevent a #DIV/0! error from plotting on a chart | Charts and Charting in Excel | |||
| DIV/0! error in SumProduct formula with no division | Excel Worksheet Functions | |||
| replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
| # DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
| "Average" with error DIV/0 | Excel Discussion (Misc queries) | |||
Threaded Mode
