Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? and other results.
hi all...
I have been working with various functions in Excel. If any function fails to retrive the result, the cell displays #NAME? or #N/A. or something denotes Error. But I need "0" display instead of the above error messages. When a Function fails or not correct the funtion the cell should display "0"(zero). Have any setting??.. please help me.. Thanks Narendra |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? and other results.
Name errors are not from failing to find a result, it's either bad spelling
or using add-ins or UDF functions without having installed them N/A errors however can be fixed like =IF(ISNA(lookup()),0,lookup()) -- Regards, Peo Sjoblom "Narendra Boga" wrote in message ... hi all... I have been working with various functions in Excel. If any function fails to retrive the result, the cell displays #NAME? or #N/A. or something denotes Error. But I need "0" display instead of the above error messages. When a Function fails or not correct the funtion the cell should display "0"(zero). Have any setting??.. please help me.. Thanks Narendra |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? and other results.
Lookup iferror function in help. An example is:-
=4/0 will return #DIV/0! Put in as =IFERROR(4/0,0) returns 0 Regards, OssieMac "Narendra Boga" wrote: hi all... I have been working with various functions in Excel. If any function fails to retrive the result, the cell displays #NAME? or #N/A. or something denotes Error. But I need "0" display instead of the above error messages. When a Function fails or not correct the funtion the cell should display "0"(zero). Have any setting??.. please help me.. Thanks Narendra |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? and other results.
Note: IFERROR function is only available in Excel 2007, otherwise you need to
use ISNA as Peo suggests, or ISERROR/ISERR "OssieMac" wrote: Lookup iferror function in help. An example is:- =4/0 will return #DIV/0! Put in as =IFERROR(4/0,0) returns 0 Regards, OssieMac "Narendra Boga" wrote: hi all... I have been working with various functions in Excel. If any function fails to retrive the result, the cell displays #NAME? or #N/A. or something denotes Error. But I need "0" display instead of the above error messages. When a Function fails or not correct the funtion the cell should display "0"(zero). Have any setting??.. please help me.. Thanks Narendra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM and IF results | Excel Worksheet Functions | |||
Why Different results | Excel Discussion (Misc queries) | |||
different results | Excel Discussion (Misc queries) | |||
Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
min or max results | Excel Worksheet Functions |