Sunday, January 2, 2011

To Add One...

Today, I engaged in one of the hardest quests in the history of mankind and excel: to create a marco that adds one without creating a replica of Pandora's Box or create a virus looping endlessly destroying the whole world.

Consulting a guide to add
(http://spreadsheets.about.com/od/tipsandfaqs/qt/new_add_excel.htm) proved to be of pitiful use, resulting in :

Which further on down the road Mr Dickson told us that it was called a circular reference.

Well, using the special paste function I solved the problem of adding one. My next problem is to create an universal formula that applies to all cells in my table, not just one since I do not want to be creating the exact same formula for the 18 cells.

No comments:

Post a Comment