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

G

Guest

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

Bob Phillips

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

--

HTH

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

Guest

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

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement containing today formula 8
Formula to display last entry in a column populated with #N/As 4
#N/A - "Value not available" 6
Formula erros =#N/A 2
Excel A CountIF question... I think 2
Correct #N/A Value 6
How can I automatically replace the error #N/A with 0 in Excel? 3
Help with a formula and cell referencing. 2

Top