How can I work around the non value (#N/A) when using formulas in.
 

I am trying to have an "automised" workbook within which I just need to
refresh the data but I am using formulas to look for information and I have
#N/A coming up because all the information is not always available. Currently
I manually change these into 0 each time I refresh it but I would like to
find an easier way. I have tried to use the if() formula but I can't get
around it. Is there somtehing to do?

=IF(ISNA(your_formula),0,your_formula)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fleur" wrote in message
...
I am trying to have an "automised" workbook within which I just need to
refresh the data but I am using formulas to look for information and I
have
#N/A coming up because all the information is not always available.
Currently
I manually change these into 0 each time I refresh it but I would like to
find an easier way. I have tried to use the if() formula but I can't get
around it. Is there somtehing to do?

Thanks !
But I didn't get the thing on the amail...
Are you working for Philips ? In which case where are you based ?

"Bob Phillips" wrote:

=IF(ISNA(your_formula),0,your_formula)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fleur" wrote in message
...
I am trying to have an "automised" workbook within which I just need to
refresh the data but I am using formulas to look for information and I
have
#N/A coming up because all the information is not always available.
Currently
I manually change these into 0 each time I refresh it but I would like to
find an easier way. I have tried to use the if() formula but I can't get
around it. Is there somtehing to do?

No, Philips is a Dutch company with one l. I am an English person with two
ls.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fleur" wrote in message
...
Thanks !
But I didn't get the thing on the amail...
Are you working for Philips ? In which case where are you based ?

"Bob Phillips" wrote:

=IF(ISNA(your_formula),0,your_formula)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fleur" wrote in message
...
I am trying to have an "automised" workbook within which I just need
to
refresh the data but I am using formulas to look for information and I
have
#N/A coming up because all the information is not always available.
Currently
I manually change these into 0 each time I refresh it but I would like
to
find an easier way. I have tried to use the if() formula but I can't
get
around it. Is there somtehing to do?