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 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 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 RANGESNext: Viewing multiple worksheets