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

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

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

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

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 -

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!!

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!

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.

Removing #N/A from formula results
 

If you have XL2007 or later, you could just wrap your formula in IFERROR()

=IFERROR(your formula,0)