General discussion

  • Creator
    Topic
  • #2175558

    Excel error

    Locked

    by lord foul ·

    When i copy cells that have an absolute cell reference using autofill i receive green auditing triangles in the top left corner of each cell (that has the answer)that has been copied to. It says there is an error howvere the answers are correct…any ideas

All Comments

  • Author
    Replies
    • #3335548

      Reply To: Excel error

      by bfilmfan ·

      In reply to Excel error

      Depending on how you set the absolute reference, that might be a bogus or a correct error reference. Take a look at this guide and let us know which absolute cell reference you used in your formula:

      http://www.awardsites.com/tutorials/excel/cell_ref-01.htm

    • #3351766

      Reply To: Excel error

      by lord foul ·

      In reply to Excel error

      I am using the first example of the absolute cell reference where it shows =B4*$B$10.

    • #3089677

      Reply To: Excel error

      by lord foul ·

      In reply to Excel error

      This question was closed by the author

Viewing 2 reply threads