| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to write an equation that ignores cells that have .
I am trying to write an equation that will ignore cells that have a result
from a previous equation of #N/A. Or is there a way to write an equation that if the answer is #N/A, the result will be zero. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to write an equation that ignores cells that have .
=IF(ISNA(YourFormula),0,YourFormula)
-- Kind regards, Niek Otten "UTmike" wrote in message ... I am trying to write an equation that will ignore cells that have a result from a previous equation of #N/A. Or is there a way to write an equation that if the answer is #N/A, the result will be zero. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to write an equation that ignores cells that have .
one way
=IF(ISERROR((PUT YOUR EQUATION HERE))),"0",(PUT YOUR EQUATION HERE))) "UTmike" wrote in message ... I am trying to write an equation that will ignore cells that have a result from a previous equation of #N/A. Or is there a way to write an equation that if the answer is #N/A, the result will be zero. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula/macro that ignores cells nonblanks | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| How do you write 2 lines of text in 1 cell rather than use 2 cells | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
