|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 13th, 2010, 02:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
remove the #n/a and make it 0
Hi
How do i remove the #n/a and make it 0 
|
|
#2
May 13th, 2010, 02:30 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove the #n/a and make it 0
you can use =if(ISNA(your_formula),0,your_formula)
On May 13, 6:22*pm, mahmoud moustafa mahmoud wrote: Hi How do i remove the #n/a and make it 0
|
|
#3
May 13th, 2010, 02:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove the #n/a and make it 0
Hi,
=if(iserror(yourformula),"",your formula) "mahmoud moustafa" wrote: Hi How do i remove the #n/a and make it 0
|
|
#4
May 13th, 2010, 02:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove the #n/a and make it 0
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
|
|
#5
May 13th, 2010, 04:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove the #n/a and make it 0
On May 13, 7:22*am, mahmoud moustafa mahmoud
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  $7,2,0), "")
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
