General discussion


Excel error

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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

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:

Collapse -

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.

Collapse -

by Lord Foul In reply to Excel error

This question was closed by the author

Related Discussions

Related Forums