Software

General discussion

Gravatar
0 Votes
Locked

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

gravatar
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:

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

gravatar
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.

gravatar
Collapse -

by Lord Foul In reply to Excel error

This question was closed by the author

Back to Software Forum

Start or search

Related Discussions

Related Forums