result returns #N/B
 

When i use a formula like " VLOOKUP ", sometimes the result is #N/B. Is it
possible to change the result in 0 (zero)? It would help me to use it in
calculations. E.g. when i use SUM and one of the results is #N/B, the result
of the SUM is #N/B.

result returns #N/B
 

in English, I'd use:

=if(iserror(vlookup(...)),0,vlookup(...))



Léon wrote:

When i use a formula like " VLOOKUP ", sometimes the result is #N/B. Is it
possible to change the result in 0 (zero)? It would help me to use it in
calculations. E.g. when i use SUM and one of the results is #N/B, the result
of the SUM is #N/B.

--

Dave Peterson

result returns #N/B
 

Hi Léon

See
http://www.contextures.com/xlFunctions02.html



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Léon" wrote in message ...
When i use a formula like " VLOOKUP ", sometimes the result is #N/B. Is it
possible to change the result in 0 (zero)? It would help me to use it in
calculations. E.g. when i use SUM and one of the results is #N/B, the result
of the SUM is #N/B.

result returns #N/B
 

Does Excel calculate VLOOKUP twice in that example?

"Dave Peterson" wrote in message
...
in English, I'd use:

=if(iserror(vlookup(...)),0,vlookup(...))



Léon wrote:

When i use a formula like " VLOOKUP ", sometimes the result is #N/B. Is
it
possible to change the result in 0 (zero)? It would help me to use it in
calculations. E.g. when i use SUM and one of the results is #N/B, the
result
of the SUM is #N/B.

--

Dave Peterson

result returns #N/B
 

Only if it's not an error. I don't think excel worries about that last portion
if it finds the error (it stops after returning 0.)

"Danny@Kendal" wrote:

Does Excel calculate VLOOKUP twice in that example?

"Dave Peterson" wrote in message
...
in English, I'd use:

=if(iserror(vlookup(...)),0,vlookup(...))



Léon wrote:

When i use a formula like " VLOOKUP ", sometimes the result is #N/B. Is
it
possible to change the result in 0 (zero)? It would help me to use it in
calculations. E.g. when i use SUM and one of the results is #N/B, the
result
of the SUM is #N/B.

--

Dave Peterson

--

Dave Peterson