Software

Ask something
Discussion Locked

Excel error

0 helpful
3 replies

by lord foul

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

3 replies

by bfilmfan

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

This discussion is closed to new replies.