Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A
Is there anyway to return "0" when a cell receives the #N/A error? Not in
the same cell, but another one so it can be used in a new formula. Ex: =IF(C81="#N/A", "0") This didn't work. Thanks for any help I can get. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A
=IF(ISNA(C81),0,C81)
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "sixthhole" wrote in message ... Is there anyway to return "0" when a cell receives the #N/A error? Not in the same cell, but another one so it can be used in a new formula. Ex: =IF(C81="#N/A", "0") This didn't work. Thanks for any help I can get. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A
There is a function called ISNA which you could use like...
=IF(isna(C81), "0", C81) -- HTH... Jim Thomlinson "sixthhole" wrote: Is there anyway to return "0" when a cell receives the #N/A error? Not in the same cell, but another one so it can be used in a new formula. Ex: =IF(C81="#N/A", "0") This didn't work. Thanks for any help I can get. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A
Thanks guys!!!!!!
"Jim Thomlinson" wrote: There is a function called ISNA which you could use like... =IF(isna(C81), "0", C81) -- HTH... Jim Thomlinson "sixthhole" wrote: Is there anyway to return "0" when a cell receives the #N/A error? Not in the same cell, but another one so it can be used in a new formula. Ex: =IF(C81="#N/A", "0") This didn't work. Thanks for any help I can get. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A
In your second post, you put the quotes back into my formula!
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jon Peltier" wrote in message ... =IF(ISNA(C81),0,C81) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "sixthhole" wrote in message ... Is there anyway to return "0" when a cell receives the #N/A error? Not in the same cell, but another one so it can be used in a new formula. Ex: =IF(C81="#N/A", "0") This didn't work. Thanks for any help I can get. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|