| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
embedding "ISERROR" function into an "IF" statement
I'm trying to add up a column of numbers and some of the cells have
#N/A or #DIV/0! which causes my summation to come up as an error as well. I'd like to keep my #N/A's in the cells and use the ISERROR function and thought it should be embedded into an IF statement. Can any help me do this? Thanks Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an "IF()" statement contain a print function | Excel Discussion (Misc queries) | |||
| Combining an If Statement with NETWORKDAYS function | Excel Discussion (Misc queries) | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
| Combining SUM Function with Nested If Statement | Excel Discussion (Misc queries) | |||
| How to resize a comment box, by embedding code into a function? | Excel Worksheet Functions | |||
Threaded Mode
