Prev: Macro to COPY FORMULA BETWEEN RANGES
Next: Viewing multiple worksheets
From: mahmoud moustafa mahmoud on 13 May 2010 09:22
Hi
How do i remove the #n/a and make it 0

From: muddan madhu on 13 May 2010 09:30
you can use =if(ISNA(your_formula),0,your_formula)



On May 13, 6:22 pm, mahmoud moustafa <mahmoud
moust...(a)discussions.microsoft.com> wrote:
> Hi
> How do i remove the #n/a and make it 0

From: Eduardo on 13 May 2010 09:35
Hi,

=if(iserror(yourformula),"",your formula)

"mahmoud moustafa" wrote:

> Hi
> How do i remove the #n/a and make it 0
>
From: JLatham on 13 May 2010 09:36
You need to "wrap" your formula with a test for the error like this:

=IF(ISNA(your formula),0,your formula)

The most common #N/A comes from VLOOKUP() results without a match, so you
might have a formula like this:
=VLOOKUP(A1,B1:J99,3,FALSE)
and you would rewrite it as
=IF(ISNA(VLOOKUP(A1,B1:J99,3,FALSE)), 0, VLOOKUP(A1,B1:J99,3,FALSE))


"mahmoud moustafa" wrote:

> Hi
> How do i remove the #n/a and make it 0
>
From: Armando on 13 May 2010 11:33
On May 13, 7:22 am, mahmoud moustafa <mahmoud
moust...(a)discussions.microsoft.com> wrote:
> Hi
> How do i remove the #n/a and make it 0

Try this one:
=IF(COUNTIF(B$2:B$7,B23),VLOOKUP(B23,B$2:D$7,2,0),"")
 | 
Pages: 1
Prev: Macro to COPY FORMULA BETWEEN RANGES
Next: Viewing multiple worksheets