Share via

#N/A errors in Data tables

Anonymous
2012-07-15T17:06:55+00:00

I have several #N/A errors in a Simulated Income table generated across five values with Iteration of 100.  There are five values ranging from $39.35 to 59.95 in $5 increments.  This is based off of a RAND function.  In creating a Simulated Profitability Statistics table to determine the AVERAGE, STDEV.S, MAX and MIN functions are also returned as #N/A.  What can I do to get rid of the #NA errors so my functions will work on this table?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2012-07-15T17:13:14+00:00

    Can you tell us what formulas are generating th #N/A errors.

    Could you poist a sample file to one of these places and give us its URL?

    Windows Live Skydrive: http://skydrive.live.com

    MediaFire: http://www.mediafire.com

    FileFactory: http://www.filefactory.com

    FileSavr: http://www.filesavr.com

    FileDropper: http://www.filedropper.com

    RapidShare: http://www.rapidshare.com

    Box.Net: http://www.box.net/files

    best wishes

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2012-07-16T00:27:20+00:00

    Since you are on Excel 2010, take a look on AGGREGATE function (Click herefor tutorial). There is an option "Ignore error values"

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2012-07-15T17:12:28+00:00
    • What is the formula returning the #N/A error value?
    • Do you want to avoid #N/A altogether or have a dfault value in the case of an #N/A?
    • Can you post several lines of sample data together with the results you expect?

    Was this answer helpful?

    0 comments No comments