=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?