LinkBack URL
About LinkBacks
Does anyone know any quick ways to change #N/A results from formulas to 0?
Thank you.
Josh
Does anyone know any quick ways to change #N/A results from formulas to 0?
Thank you.
Josh
With 2007, have a look at the IFERROR() function.
Last edited by Marcol; 08-05-2013 at 08:12 PM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Marcol,
If I already have about 500 formulas in play, how could I add this function to existing formulas?
=IFERROR(your formula,0)
Ctrl+G (Soto), Special, Errors. Type 0 in the formula bar, press and hold the Ctrl key, then press Enter.
Entia non sunt multiplicanda sine necessitate
Do you really have 500 formulae in your Workbook/Worksheet, or are most of them not the same formula filled down?
There really are about 500 formulas but yes, most of them are the same filled down.
SHG, that was great and that worked. However, it did change some errors that I didn't need changed, but you just taught me something that I can definitely use. Thanks!
@ Shg doesn't that just overwrite all the folmulae that return errors with 0?
Marcol, that is what I was getting at as well.
You can change the formulas or change the values. I don't know of a third alternative.
A brutal way would be to use VBa
Select the range that you need to wrap all existing formulae in IFERROR() then run this macro
This could be refined if required, as it stands it will mask all errors.
Please Login or Register to view this content.
Hi,
Please try using ISERROR
Sample to use ISERROR:
=IF(ISERROR(MATCH(A2,A2:A4,0)),"",A2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks