Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing #N/A from formula results
Hi All,
Is there a way to remove #N/A as a result from a formula, for example to return a blank or zero result instead? -- Cheers, Holly |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing #N/A from formula results
Wrap your formula in an IF statement.....
=IF(ISNA(YourFormula),"",YourFormula) Vaya con Dios, Chuck, CABGx3 "Holly" wrote in message ... Hi All, Is there a way to remove #N/A as a result from a formula, for example to return a blank or zero result instead? -- Cheers, Holly |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing #N/A from formula results
Something along these lines:
=IF(ISNA(your_formula),"",your_formula) This returns a blank instead of #N/A - change the "" to 0 if you prefer a zero. Hope this helps. Pete On Jan 18, 1:15*am, Holly wrote: Hi All, Is there a way to remove #N/A as a result from a formula, for example to return a blank or zero result instead? -- Cheers, Holly |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing #N/A from formula results
My Formula is a v lookup as follows:
=VLOOKUP(D223,Cashflow!P:R,3,FALSE) -- Cheers, Holly "CLR" wrote: Wrap your formula in an IF statement..... =IF(ISNA(YourFormula),"",YourFormula) Vaya con Dios, Chuck, CABGx3 "Holly" wrote in message ... Hi All, Is there a way to remove #N/A as a result from a formula, for example to return a blank or zero result instead? -- Cheers, Holly |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing #N/A from formula results
Then change it to this:
=IF(ISNA(VLOOKUP(D223,Cashflow!P:R,3,FALSE)),"",VL OOKUP(D223,Cashflow! P:R,3,FALSE)) Hope this helps. Pete On Jan 18, 1:28*am, Holly wrote: My Formula is a v lookup as follows: =VLOOKUP(D223,Cashflow!P:R,3,FALSE) -- Cheers, Holly "CLR" wrote: Wrap your formula in an IF statement..... =IF(ISNA(YourFormula),"",YourFormula) Vaya con Dios, Chuck, CABGx3 "Holly" wrote in message ... Hi All, Is there a way to remove #N/A as a result from a formula, for example to return a blank or zero result instead? -- Cheers, Holly- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing #N/A from formula results
On Thursday, January 17, 2008 8:15:01 PM UTC-5, Holly wrote:
Hi All, Is there a way to remove #N/A as a result from a formula, for example to return a blank or zero result instead? -- Cheers, Holly Awesome!! Big help!! Thank you very much!! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing #N/A from formula results
On Thursday, January 17, 2008 8:21:08 PM UTC-5, CLR wrote:
Wrap your formula in an IF statement..... =IF(ISNA(YourFormula),"",YourFormula) Vaya con Dios, Chuck, CABGx3 "Holly" wrote in message ... Hi All, Is there a way to remove #N/A as a result from a formula, for example to return a blank or zero result instead? -- Cheers, Holly Awesome!! Big Help! Thank you very much! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing #N/A from formula results
Hi, what if my formula a
=VLOOKUP(E4,'Hidden Local Database'!$L$1:M$5000,2,FALSE) =C4*G4 =sum(I4:I300) Can you write me a formula returning 0 instead of #N/A. Thanks alot. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing #N/A from formula results
If you have XL2007 or later, you could just wrap your formula in IFERROR()
=IFERROR(your formula,0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula help! Removing a neg# & #DIV/0! | Excel Discussion (Misc queries) | |||
Clear Cell Without Removing Formula | Excel Worksheet Functions | |||
keep number when removing formula | Excel Discussion (Misc queries) | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions |